출처 :<a href="http://www.sqler.com/271911" target="_blank" class="tx-link">&nbsp;http://www.sqler.com/271911</a> SELECT A.job_id, A.name, A.enabled,description, A.date_created, A.date_modified ,D.step_id, D.step_name, D.subsystem, D.database_name, D.commandFROM msdb.dbo.sysjobs A INNER JOIN msdb.dbo.sysjobschedules B ON A.job_id = B.job_idINNER JOIN msdb.dbo.sysschedules C ON B.schedule_id = C.schedule_idINNER JOIN msdb.dbo.sysjobsteps D ON A.job_id = D.job_idORDER BY A.job_id, D.step_id













&nbsp;

SQL Server 에이전트 작업 리스트 출력 쿼리 Printing task-list in SQL Agent