T sql script to alter SQL Server agent job if exists
Posted on 2014-01-12
Could you please help me with T-Sql script to alter SQL Server agent job. If the job exists, then I need to alter the job script ,to add more steps and also edit the existing steps.
I don't want to add it manually through wizard as we want to run the T-Sql scripts only (as we don't have access to production environments)
I need a sample Alter script . Your help is greatly appreciated in this regard.
Please Note : I don't want to drop and create the existing job in production as I would loose history of the job.