I am trying to copy agent jobs from one server to another with the schedule and then deactivate the jobs. Does anyone know of a solution or article that explains how to programatically copy agent jobs?
Just as I would select multiple jobs then right click and script them out, I would like to script out the jobs that exist and then create them on a different server. I think I will need to drop and then add the jobs in the event the same job is moved several times. Then I will have to move the schedule as well. And then finally, inactivate the job.
Just as I would select multiple jobs then right click and script them out, I would like to script out the jobs that exist and then create them on a different server. I think I will need to drop and then add the jobs in the event the same job is moved several times. Then I will have to move the schedule as well. And then finally, inactivate the job.
