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 !!!
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:
Hi
I tried to take all jobs script backup on SQL 2005...i am able to take particular job only
Use CTRL+A
select all jobs
right click and script it
I think you are missing something
Post a Comment