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:

A.S. Reddy said...

Hi
I tried to take all jobs script backup on SQL 2005...i am able to take particular job only

Unknown said...

Use CTRL+A
select all jobs
right click and script it

I think you are missing something

Post a Comment

Popular Posts