Need a script to recreate scheduled jobs

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • traceable1
    #1

    Need a script to recreate scheduled jobs


    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
    Tags: None
    • Erland Sommarskog
      #2
      Re: Need a script to recreate scheduled jobs

      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@sommarsk og.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

        Comment

        Previous template Next
        Working...