Prev: Help needed for Data formatting.
Next: sql agent JOB to Backup Database and Maintain Backup Files
From: traceable1 on 30 Jun 2008 14:13

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
From: Erland Sommarskog on 30 Jun 2008 18:08
traceable1 (thhamlin(a)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(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: Help needed for Data formatting.
Next: sql agent JOB to Backup Database and Maintain Backup Files