Monday, March 18, 2013

MSSQL jobs may be migrated from one server to another.

  1. 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.
  2. In the "Object Explorer" click on "Jobs" beneath "SQL Server Agent" which will display a list of jobs in the "Object Explorer Details" pane.
  3. Select all the jobs and then right-click on the selection.
  4. pick: Script job as > CREATE To > File ...
  5. 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.
  6. 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.
  7. At the upper left there will be a "Schedules" option. Use this to adjust the schedule for each job.
  8. 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