Delete Job by Name

Posted by Derek D. on SQL Server Planet See other posts from SQL Server Planet or by Derek D.
Published on Tue, 20 Apr 2010 15:33:35 +0000 Indexed on 2010/04/20 15:34 UTC
Read the original article Hit count: 360

Filed under:
When scripting out jobs using ssms (sql server management studio) the default script for a drop statement is to drop the job according to it’s job_id. This is not beneficial however when pushing code to different environments. Job_id’s are specific to the windows environment in which they are created. To get around [...]

© SQL Server Planet or respective owner

Related posts about DBA