I wants Confirming the Jobs on the sql server by use query

Hello ! ^^
I'm Jae sik in South Korea
I have win2003 (64 bit DataCent Ed) and sql 2000 64 bit Ed. and 1:1
Cluster
I wants Confirming the Jobs on the sql server by use query
How can i do this ?
Thanks.
If I understand that you want to see the SQL Server Agent
Jobs, then you will find that information in the [msdb]
database.
There are three tables that I look at to try to weed my way
an undocumented system. (fun!!!!)
[sysjobs]
[sysjobsteps]
[sysjobschedules]
All in [msdb]
all tables relate to the column [job_id] in
the [sysjobs] tables.
I hope that is what you're looking for, but if not, please
clarify.
Good Luck!
jg

Quote:

Originally posted by
Hello ! ^^
I'm Jae sik in South Korea
I have win2003 (64 bit DataCent Ed) and sql 2000 64 bit Ed. and 1:1
Cluster
I wants Confirming the Jobs on the sql server by use query
How can i do this ?
Thanks.

|||Hi
If I understand you correctly, you are asking how to check the status of SQL
Agent Jobs.
In MSDB, there are the tables called sysjobs, systasks and sysjobsteps.
Querying those will give you the information.
For a complete map of the system tables, get systbl.chm from
http://www.microsoft.com/sql/techinf.../systables.asp
Regards
Mike
"1?à???" wrote:

> Hello ! ^^
> I'm Jae sik in South Korea
> I have win2003 (64 bit DataCent Ed) and sql 2000 64 bit Ed. and 1:1
> Cluster
> I wants Confirming the Jobs on the sql server by use query
> How can i do this ?
> Thanks.
>
>
|||Thanks mike epprecht
"" <jsmin@.techdata.co.kr> wrote in message
news:#5utCWT$EHA.2196@.TK2MSFTNGP14.phx.gbl...
> Hello ! ^^
> I'm Jae sik in South Korea
> I have win2003 (64 bit DataCent Ed) and sql 2000 64 bit Ed. and 1:1
> Cluster
> I wants Confirming the Jobs on the sql server by use query
> How can i do this ?
> Thanks.
>