I had to create a deployment script today which included modifications to an existing job. Ideally the normal process requires taking backup of the existing object and then implementing the modified object.
Could not find a built in function to rename the job, so my approach was to delete schedule of the existing job and create a new job with a different name (appended v2 i.e. version 2) with the same schedule.
sp_delete_jobschedule
@job_name = N'my existing job name',
@name = N'existing schedule name'
No comments:
Post a Comment