Skip to content

Instantly share code, notes, and snippets.

@GER-NaN

GER-NaN/SqlServerJobSearch.sql

Created January 17, 2017 20:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save GER-NaN/6c14db46e81db8e0bb495cd66b0da333 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save GER-NaN/6c14db46e81db8e0bb495cd66b0da333 to your computer and use it in GitHub Desktop.
Download ZIP
Queries the Sql Server Job Steps for a specified search key
Raw
SqlServerJobSearch.sql
USE [msdb]
GO
--QUERIES the Job Steps for a specific search key.
DECLARE @SearchKey VARCHAR(100) = 'dev'
SELECT
sysjobs.job_id,
sysjobs.name,
sysjobs.name,
sysjobsteps.step_id,
sysjobsteps.command,
sysjobsteps.step_name
FROM
dbo.sysjobs INNER JOIN
dbo.sysjobsteps ON sysjobsteps.job_id = sysjobs.job_id
WHERE
sysjobsteps.command LIKE N'%' + @SearchKey + '%'
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment