MS SQL Server, WINNT SP6a: SQL Server Agent

WINNT SP6a: SQL Server Agent

Author	Message
Mike Mullan #1 / 4	WINNT SP6a: SQL Server Agent SQL Server Agent is not always restarting itself after a server reboot or restart of SQL Server. I would like to setup someway of checking all servers to see if the Agent is running. Any suggestions as to the best way to do this would be helpful. Mike
Tue, 09 Dec 2003 06:19:10 GMT

Gert E.R. Draper #2 / 4	WINNT SP6a: SQL Server Agent Create a stored proc create proc sp_autostart_sqlagent as set nocount on exec master.dbo.xp_servicecontrol 'START', 'SQLAgent$DEV' go Make the SP auto start exec master.dbo.sp_procoption 'sp_autostart_sqlagent', 'startup', 'true' This will make sure that you always start SQL Agent if you start SQL Server. -GertD Quote: > SQL Server Agent is not always restarting itself after a server reboot or > restart of SQL Server. > I would like to setup someway of checking all servers to see if the Agent is > running. Any suggestions as to the best way to do this would be helpful. > Mike
Tue, 09 Dec 2003 14:26:51 GMT

Neil Pik #3 / 4	WINNT SP6a: SQL Server Agent Mike - you need an NT level tool that will check for a service running - there are several commercial/shareware of these on the market. Just do an internet search for service, nt, monitor and restart Quote: > SQL Server Agent is not always restarting itself after a server reboot or > restart of SQL Server. > I would like to setup someway of checking all servers to see if the Agent is > running. Any suggestions as to the best way to do this would be helpful. > Mike Neil Pike MVP/MCSE. Protech Computing Ltd Reply here - no email SQL FAQ (484 entries) see http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps (faqxxx.zip in lib 7) or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800 or www.sqlserverfaq.com or www.mssqlserver.com/faq
Tue, 09 Dec 2003 18:10:18 GMT

Mike Mullan #4 / 4	WINNT SP6a: SQL Server Agent Thanks guys. Quote: > Create a stored proc > create proc sp_autostart_sqlagent > as > set nocount on > exec master.dbo.xp_servicecontrol 'START', 'SQLAgent$DEV' > go > Make the SP auto start > exec master.dbo.sp_procoption 'sp_autostart_sqlagent', 'startup', 'true' > This will make sure that you always start SQL Agent if you start SQL Server. > -GertD > > SQL Server Agent is not always restarting itself after a server reboot or > > restart of SQL Server. > > I would like to setup someway of checking all servers to see if the Agent > is > > running. Any suggestions as to the best way to do this would be helpful. > > Mike
Tue, 09 Dec 2003 22:51:55 GMT

Page 1 of 1

[ 4 post ]