Post reply

Retrieving command code for from previous version of a job

  • March 1, 2004 at 2:35 pm

    #160507

    We have a scheduled job that the command has been changed and I would like to restore the old version of the script.  There do not appear to be copies of the script outside of the a backup that is made each day.

    Any ideas as to how I can quickly retrieve the previous version of the job command.

    Thanks.

  • March 1, 2004 at 2:42 pm

    #496537

    Job scripts are maintained in msdb  sysjobsteps table, if you have earlier backups of that then you can restore it but if you don't it is going to be difficult

     


    * Noel

  • March 1, 2004 at 2:46 pm

    #496539

    SQL Server does not version the job command? 

  • March 1, 2004 at 3:17 pm

    #496544

    Nope. And by default MSDB is set to simple recovery, so you can't normally use a tool like Lumigent to rollback the change. Best bet is to restore MSDB under a different name and grab what you need.

    Andy
    Connect with me on LinkedIn

  • March 1, 2004 at 3:24 pm

    #496547

    SQL Server KEEPS versions of DTS packages

    1. AFAIK version_number from sysjobs is incremented everytime it changes but the earlier version is not kept


    * Noel

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

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