DECLARE @jobId uniqueidentifier = NULL
SELECT @jobId = job_id FROM msdb.dbo.sysjobs WHERE (name = N'JobName')
IF (@jobId IS NOT NULL)
BEGIN
EXEC msdb.dbo.sp_delete_job @job_id = @jobId, @delete_unused_schedule = 1;
SET @jobId = NULL
END
EXEC @ReturnCode = [msdb].dbo.sp_add_job @job_name=N'JobName',
@enabled=1,
@notify_level_eventlog=0,
@notify_level_email=0,
@notify_level_netsend=0,
@notify_level_page=0,
@delete_level=0,
@description=N'No description available.',
@category_name=N'[Uncategorized (Local)]',