MSSQL jobs may be migrated from one server to another.
- At the server you will migrate FROM, open the "Object Explorer" and the "Object Explorer Details" from the "View" menu in Microsoft SQL Server Management Studio.
- In the "Object Explorer" click on "Jobs" beneath "SQL Server Agent" which will display a list of jobs in the "Object Explorer Details" pane.
- Select all the jobs and then right-click on the selection.
- pick: Script job as > CREATE To > File ...
- After saving out the SQL to create the server's jobs, run the SQL script at the server you wish to migrate to in Microsoft SQL Server Management Studio.
- Make a list of jobs on the new server in SSMS as before and right-click on each job and pick "Properties" to bring up the "Job Properties" pane.
- At the upper left there will be a "Schedules" option. Use this to adjust the schedule for each job.
- There is an option here for "Notifications" too. One may specify here that a the server emails an operator "When the job fails" (and one may create the operators at "Operators" beneath "SQL Server Agent" in the "Object Explorer").
No comments:
Post a Comment