作业过程查找

SELECT  s1.name,command,text
FROM    ( SELECT    name, LTRIM(REPLACE(command, 'exec ', '')) command
          FROM      [msdb].[dbo].[sysjobs] jobs
                    RIGHT  JOIN [msdb].[dbo].[sysjobsteps] steps ON jobs.job_id = steps.job_id
          WHERE     LEFT(LTRIM(command), 4) = 'exec'
                    AND jobs.name IS NOT NULL
        ) s1
        JOIN ( SELECT   A.name, B.text, B.colid
               FROM     sysobjects A ,
                        syscomments B
               WHERE    A.id = B.id
                        AND A.type = 'P'
                        AND B.text LIKE '%' + 'studentNum ' + '%'
             ) s2 ON s1.command = s2.name