DropJobMOTokenCleanup.ps1

USE [msdb]

BEGIN TRANSACTION;

DECLARE @ReturnCode INT;
SELECT @ReturnCode = 0;

DECLARE @JobCategory NVARCHAR(MAX);
SET @JobCategory = N'[Managementoverzichten]';

DECLARE @JobName NVARCHAR(MAX);
SET @JobName = N'MO Token Cleanup';

DECLARE @JobId BINARY(16);

SELECT @JobId = job_id FROM msdb.dbo.sysjobs WHERE (name = @JobName);
IF (@JobId IS NOT NULL)
BEGIN
    EXEC msdb.dbo.sp_delete_job @JobId;
END

COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
    IF (@@TRANCOUNT > 0) ROLLBACK TRANSACTION
EndSave: