Groups | Blog | Home
all groups > sql server replication > october 2005 >

sql server replication : running jobs


sqldbapree
10/27/2005 2:59:37 PM
Hi all,
We have 2 merge replication jobs. I want to complete one job and then
start another job after the first one is completed. Is there any way,
that I can make the first job to trigger the second job as soon as it
is over?
Thanks in advance.
Thanks,
Preeths.
Paul Ibison
10/28/2005 9:30:42 AM
Preeths,
you can use sp_start_job as a job step in the first step to begin the second
job.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button