摘要:[MSSQL] syscomments V sysjobsteps
SELECT object_name(id) FROM syscomments WHERE text LIKE '%FQA_SAMPLE%'
SELECT job.job_id,notify_level_email,name,enabled,description,step_name,command,server,database_name
FROM msdb.dbo.sysjobs job JOIN msdb.dbo.sysjobsteps steps ON job.job_id = steps.job_id
WHERE job.enabled = 1