How to copy a job from prod to dev

Question

How to copy a job from prod to dev

satish bobba-490352

Old Hand

Points: 366
More actions
September 14, 2007 at 12:35 pm

#180838

I need to synchronise the dev environment with production for some of the ETL jobs that are present under jobs in SQL Server agent. How to copy a job in SQL Server agent from Production to dev server.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GP Van Eron SSCarpal Tunnel Points: 4626 More actions · Answer 1

Hello,

In SS 2005 I would go into the management studio. Under SQL Server Adent I would right click on the job you want ot copy and 'Script Job As' -> 'CREATE TO' -> 'Clipboard. Than I would copy/paste this script into a new query window on the server that you want to create this on.

Please make sure you copy and DTS/SSIS packages/SPs that these jobs execute first.

Thanks!

GP

satish bobba-490352 Old Hand Points: 366 More actions · Answer 2

I tried to paste in the new server. But it didn't replace the existing version. When I view the job steps till it showing the same steps as earlier.

Please advice.

GP Van Eron SSCarpal Tunnel Points: 4626 More actions · Answer 3

Hello,

If your scripting it as a CREATE you would need to delete the job prior to executing the CREATE script. I don't believe it will give you the option to creat an ALTER script on a job.

Thanks!

GP