Last active
November 15, 2021 17:47
-
-
Save Laim/cfcbfd4b7d316aaca8a78954910eeac3 to your computer and use it in GitHub Desktop.
Delete all SQL Jobs that are assigned to LicenseManagerUser
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
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