Script out all SQL Jobs – MSDN TSQL forum
–> Question:
Hi experts,
I have approx 200 jobs in production env.
Can any one give me the script, which will script all SQL Jobs for me. I wont need any manual process please, any code, or shell script which script all SQL Jobs so that I can have some sort of backup for them, MSDB backup is not choice.
–> My Answer:
In SSMS, open “Object Explorer Details” by pressing F7.
Go to “SQL Agent” -> Jobs -> Select all jobs, Right click and “Script Job as” -> “Create to”
All, Jobs will be scripted at once.
Ref link.
Categories: SQL Tips
MSDN TSQL forum, Script SQL
Comments (0)
Trackbacks (0)
Leave a comment
Trackback