sql server replication: Hi,
I set up schedule of snapshot agent running once every day and a
subscriber agent after it. It was doing well. However, when I restart SQL
server using service manager every time, all schedules never run after the
restart. Is there any setting I can change to let agents start automatically
after SQL service restart ?


Regards,


Daniel Tsai

--
Message posted via SQLMonster.com

You need to ensure that the sql server agent itself restarts, eg.
use master
go
CREATE PROCEDURE spAgentStartup
AS
exec master.dbo.xp_cmdshell 'net start SQLAgent$pdslive'

GO
exec sp_procoption N'spAgentStartup', N'startup', N'true'
GO
Cheers, Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)