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
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
/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
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
Subscribe to:
Posts (Atom)