I have around 25 sql servers(sql server 2000) all on windows server 2003. i would like to know if anyone has a script that will poll all the servers and check to make sure the agent is running.
thanks for your helpI have around 25 sql servers(sql server 2000) all on windows server 2003. i would like to know if anyone has a script that will poll all the servers and check to make sure the agent is running.
thanks for your help
These can help you
http://www.databasejournal.com/features/mssql/article.php/3491201
http://www.sqlservercentral.com/articles/Administering/longrunningjobs/1897/|||Try these:
exec master..xp_servicecontrol querystate, MSSQLSERVER
exec master..xp_servicecontrol querystate, SQLServerAgent
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment