[sql]SELECT j.name
FROM msdb.dbo.sysjobs AS j
WHERE EXISTS
(
SELECT 1 FROM msdb.dbo.sysjobsteps AS s
WHERE s.job_id = j.job_id
AND s.command LIKE ‘%store_proc_name%’
);
[/sql]
[sql]SELECT j.name
FROM msdb.dbo.sysjobs AS j
WHERE EXISTS
(
SELECT 1 FROM msdb.dbo.sysjobsteps AS s
WHERE s.job_id = j.job_id
AND s.command LIKE ‘%store_proc_name%’
);
[/sql]
Copyright © 2024 | WordPress Theme by MH Themes
Leave a Reply