Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft SQL Server > Need a script t...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 11196 of 11409
Post > Topic >>

Need a script to recreate scheduled jobs

by traceable1 <thhamlin@[EMAIL PROTECTED] > Jun 30, 2008 at 11:13 AM

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
 




 2 Posts in Topic:
Need a script to recreate scheduled jobs
traceable1 <thhamlin@[  2008-06-30 11:13:58 
Re: Need a script to recreate scheduled jobs
Erland Sommarskog <esq  2008-06-30 22:08:20 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Oct 6 15:39:50 CDT 2008.