查看sqlserver哪个定时器执行了对应的存储过程

USE msdb; GO SELECT j.name AS 作业名称, j.enabled AS 是否启用, s.step_id AS 步骤ID, s.step_name AS 步骤名称, s.command AS 步骤命令, s.database_name AS 目标数据库 FROM dbo.sysjobs AS j INNER JOIN dbo.sysjobsteps AS s ON j.job_id s.job_id WHERE s.command LIKE %proc_name% -- 在这里替换你的存储过程名 ORDER BY j.name, s.step_id; EXEC dbo.sp_help_jobactivity job_name N作业名称;