Post reply

script job as sql, .... and back again.

  • August 24, 2009 at 8:34 am

    #135684

    I understand how to script a job that I have created in SQL server agent/jobs as an SQL statement, which is handy as a backup, but supposing that I had a catastrophic failure of SQL server and had to reinstall everything again, is there a way to recreate the job using the sql script created, please ?

  • August 24, 2009 at 8:41 am

    #1043670

    You just run the script. That's the idea behind the scripting feature. You run that script on another server to recreate the job.

  • August 24, 2009 at 8:46 am

    #1043677

    Thank you for that, but how do I get it to appear in the Job List, please ?

  • August 24, 2009 at 8:50 am

    #1043679

    When you run the script, it will appear.

    The script has calls to sp_create_job, etc. that is exactly the same things run by SSMS when you build the job in the GUI. If it doesn't appear when you run it, refresh.

  • August 24, 2009 at 8:57 am

    #1043690

    Fantastic !, thank you ever so much 🙂

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

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