Search

Monday, June 24, 2013

Procedures / Commands used in Sql Server Jobs

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 msdbGOSELECT sj.name AS job_name, st.commandFROM sysjobs sjJOIN sysjobsteps stON sj.job_id = st.job_idYou can use a where clause to get to know about procedures / command used in a particular jobs:where st.command like '%Proc_toFind%'