查询sql agent job的明细

SELECT b.[name] [JobName],b.enabled [Enabled],a.step_id[StepID],b.description [JobDescription],a.step_name [StepName],a.command [Script]FROM msdb.dbo.sysjobsteps aINNER JOIN msdb.dbo.sys

ijwsoft

2283人浏览 · 2012-12-27 15:51:21

ijwsoft · 2012-12-27 15:51:21 发布

SELECT b.[name] [JobName]
	,b.enabled [Enabled]
	,a.step_id	[StepID]
	,b.description [JobDescription]
	,a.step_name [StepName]
	,a.command [Script]
FROM msdb.dbo.sysjobsteps a 
INNER JOIN msdb.dbo.sysjobs b 
	ON a.job_id=b.job_id