Tag Info

Hot answers tagged


The script is loosely based on this one in the accepted answer. It has been updated for SQL 2014, with exception handling, atomic transactions, and a few other improvements. -- Script for SQL 2014 DECLARE @JobID UNIQUEIDENTIFIER declare @servername sysname set @servername = @@SERVERNAME SELECT @JobID = job_id FROM msdb_old.dbo.sysjobs WHERE name='My ...

Only top voted, non community-wiki answers of a minimum length are eligible