Copy SQL Server Agent Job

[ChewDoggie]

Hello All,

We're attempting to copy some SQL Server Agent Jobs from one server to another.

We went on the old server, right-clicked on the job, selected 'Script Job As', then selected 'Create To', then selected 'New Query Editor Window'. The script to create the job appeared in the window. Then we disconnected from the old server and connected to the new server and 'Executed' the script. The output said, "command completed successfully", or something to that effect.

But when we right-click on the Jobs folder in SQL Server, and refresh the list, the job doesn't appear. Another strange thing, if we re-connect to the old server, there are now TWO of the jobs in the Jobs Folder on that server.

Does anyone know what's going on ?

FYI...we did not accidently reconnect to the old server before running the script.

Chew

10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[ChewDoggie]

We were never able to re-create the Jobs via the scripts. So, we just went into the Job Activity Monitor, double-clicked on a job and then copied the params from one existing job to a new job on the new server.

Closed post.

C.


10% of your life is what happens to you. 90% of your life is how you deal with it.