August 27, 2001 at 12:56 pm
Well in an effort to catalog everything I've started the great scripting project! I already script backups, restores, adding/deleting users and general setup after initial install. What I'm looking for now is a way to add scheduled task via t-sql scripts instead of going to every box and using EM to add all the jobs etc that needed to be added that way any goober can do one of our standard installs with the side bonus of all the info being locked away in source safe for future DBA's we may hire. Any ideas?
Wes
August 27, 2001 at 4:08 pm
You just need to add your jobs to each server? How about using the master server functionality that lets you administer all jobs from one server?
Andy
August 28, 2001 at 1:58 am
I agree with Andy, use the master-server functionality if possible. Take a look at these sprocs in msdb:
* sp_add_job
* sp_add_jobstep
* sp_update_job
* sp_add_jobschedule
* sp_add_jobserver
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
August 28, 2001 at 9:23 am
Well, I looked at that but every customer will not be able to talk to a master. I'll look at the sp's and get on it!
Thanks,
Wes
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply