Showing posts with label hihow. Show all posts
Showing posts with label hihow. Show all posts

Saturday, February 25, 2012

Schedule for the sqlagent from the command line

hi
How do I set-up a schedule for the sqlagent from the command line
/Erik
Erik,
presumably you're referring to a particular job rather than the agent, so
for this you'd need to use "sp_update_jobschedule".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

Schedule for the sqlagent from the command line

hi
How do I set-up a schedule for the sqlagent from the command line
/ErikErik,
presumably you're referring to a particular job rather than the agent, so
for this you'd need to use "sp_update_jobschedule".
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com