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

Mike Epprecht (SQL MVP)
1/18/2005 7:51:03 AM

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/techinfo/productdoc/2000/systables.asp

Regards
Mike

[quoted text, click to view]

¹ÎÀç½Ä
1/18/2005 5:12:44 PM

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.

¹ÎÀç½Ä
1/20/2005 11:59:35 AM

Thanks mike epprecht

[quoted text, click to view]

¹ÎÀç½Ä
1/20/2005 5:44:39 PM

Thank you ^^
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

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