Need script to recreate scheduled jobs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

traceable1 - 30 Jun 2008 19:29 GMT

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

Reply to this Message

Tibor Karaszi - 01 Jul 2008 00:13 GMT

I would install a junk instance somewhere I can play with (making sure proper build level) and when
slide in the msdb files into that and let SSMS script whatever you need fro msdb.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> I created a new database instance, but I forgot to script out the
> scheduled jobs before I wiped out the original database instance. I
[quoted text clipped - 7 lines]
> Thanks,
> trace

Reply to this Message