By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,199 Members | 1,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,199 IT Pros & Developers. It's quick & easy.

Need a script to recreate scheduled jobs

P: n/a

I created a new database instance, but I forgot to script out the
scheduled jobs before I wiped out the original database instance. I
have attached the original msdb database as msdb_old onto the new
instance, but I need a script to pull out the require information from
sysjobs, etc. to recreate the jobs.

Please help!

Thanks,
trace
Jun 30 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
traceable1 (th******@gmail.com) writes:
I created a new database instance, but I forgot to script out the
scheduled jobs before I wiped out the original database instance. I
have attached the original msdb database as msdb_old onto the new
instance, but I need a script to pull out the require information from
sysjobs, etc. to recreate the jobs.
Why not install another instance somewhere, and stick in your old msdb
into that instance, and then script from there?

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 30 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.