How to script all the SQL Jobs from SQL Server Management studio?
Step 1: Go to SQL Server Mgmt Studio.
Step 2: Expand SQL Server Agent >> Jobs
Step 3: Hit F7 (or) goto menu View >> Summary
Step 4: Now ALL jobs would be listed out there.
Step 5: Make use of Control key and choose all the JOBs you want to script. (OR) If you want to script everything press Ctrl + A
Step 6: Right click >> "Script Job as" >> "Create To" >> File
Now you can make use of this file to create these jobs in your destination SQL Server Database.
0 comments:
Post a Comment