It is very difficult to find a procedures / Commands used in SQL Server Jobs from the huge cluster of Jobs through SQL Server Management Studio. You can get a list of all the Procedures / commands that are used in Sql Server Jobs.
USE msdb
GO
SELECT sj.name AS job_name, st.command
FROM sysjobs sj
JOIN sysjobsteps st
ON sj.job_id = st.job_id
You can use a where clause to get to know about procedures / command used in a particular jobs:
where st.command like '%Proc_toFind%'
USE msdb
GO
SELECT sj.name AS job_name, st.command
FROM sysjobs sj
JOIN sysjobsteps st
ON sj.job_id = st.job_id
You can use a where clause to get to know about procedures / command used in a particular jobs:
where st.command like '%Proc_toFind%'
No comments:
Post a Comment