November 5, 2008 at 8:06 pm
Hi there,
I am a bit of newbie to SQL Server Agent, and the answer to this question may or may not be simple I am not sure.
I have created a snapshot replication for a database and have set this to "run on demand". The replication is available as a Job under SQL Server Agent. I can run the Job by right-clicking the job in the object explorer and selecting "start job".
However, I would like to execute the job through script? Is this possible?
Any help would be appreciated.
Thanks
Scott
November 6, 2008 at 10:34 am
Lookup sp_start_job in BOL. That is the command you need to start a job in a SQL Script.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 6, 2008 at 1:04 pm
Thanks Jack, that was it 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply