Saturday, August 20, 2016

SQL Agent - Script out all jobs

http://www.sqlmatters.com/Articles/Scripting%20all%20Agent%20Jobs%20Using%20SQL%20Server%20Management%20Studio%20(SSMS).aspx


  • In SQL Management Studio, navigate to SQL Server Agent>Jobs
  • Click View>Object Explorer Details
  • Select All Jobs
  • Right click>Script

No comments:

Post a Comment