Script SQL Server Jobs

                As a part of backup routine or server migration we have to script jobs and then move them to other server. We all are used to SSIS for moving jobs from one server to other server
Another option is to
script all jobs. Then replace necessary login and server name in the script and execute them at the target server

Lets see how to do it

In SSMS in go to jobs. Open object explorer details window at the right side of SSMS
Then select jobs which we want to script right click it and script it. So simple !!!




2 comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts