Post reply

backup all jobs

  • June 8, 2004 at 5:18 am

    #108072

    I still havent found a system or procedure which would backup all sql jobs with all their settings (owner, schedule etc.)

    Is there anyone who has solved such a problem already?

  • June 8, 2004 at 12:41 pm

    #509548

    To script the jobs:

    In EM right click the Jobs icon under SQL Server Agent and choose Tasks -> Generate SQL Script.

    Otherwise BACKUP the msdb database, which is where all the jobs are stored.

    /rockmoose


    You must unlearn what You have learnt

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply