Skip to content

Instantly share code, notes, and snippets.

@Laim
Last active November 15, 2021 17:47
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Laim/cfcbfd4b7d316aaca8a78954910eeac3 to your computer and use it in GitHub Desktop.
Save Laim/cfcbfd4b7d316aaca8a78954910eeac3 to your computer and use it in GitHub Desktop.
Delete all SQL Jobs that are assigned to LicenseManagerUser
/*
Author: Laim McKenzie
Website: https://laim.scot
Version: 1.0
Modified version of https://sqlgeekspro.com/script-to-delete-sql-agent-jobs/
*/
DECLARE @SQLStatement VARCHAR(200)
DECLARE @jobName SYSNAME
DECLARE c1 CURSOR FOR
SELECT name FROM msdb.dbo.sysjobs_view WHERE owner_sid = (SELECT SUSER_SID('LicenseManagerUser'))
OPEN c1
FETCH NEXT FROM c1 INTO @jobName
IF @@CURSOR_ROWS=0
PRINT 'No Job found! Please re-check line 12.'
WHILE @@fetch_status=0
BEGIN
SET @SQLStatement= 'EXEC msdb.dbo.sp_delete_job @job_name =''' + @jobName + ''', @delete_unused_schedule=1'
PRINT(@SQLStatement) -- COMMENT OR DELETE LINE WHEN YOU WANT TO DELETE DATA.
--EXEC (@SQLStatement) -- UNCOMMENT TO DELETE JOBS.
FETCH NEXT FROM c1 INTO @jobName
END
CLOSE c1
DEALLOCATE c1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment