- Open the server in the Object Explorer.
- Open the "Object Explorer Details" window.
- In the "Object Explorer Details" window, drill down to "SQL Server Agent"
- Drill down to "Jobs"
- Select the jobs you want to script.
- Right click and select "Script Job as", then "Create To", and select where you want them scripted to.
- Remember to filter out any "SSRS" jobs. (exclude any job name that contains a hyphen).
AWS, data engineering, sql server, talend, postgres, business intelligence, car diy, photography
Search
Tuesday, 12 October 2010
[SQL] Scripting out Jobs in SSMS
I found that you can script out all jobs from Management Studio.
Labels:
dr,
management studio,
mssql,
script,
scripting,
SQL,
SQL SERVER,
ssms,
tsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment