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 !

Thanks,
trace

traceable1 (thhamlin@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, esquel@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