Saturday, 15 June 2013

tsql - In SSMS is there a way to export a list of job steps in a SQL Server Agent job? -



tsql - In SSMS is there a way to export a list of job steps in a SQL Server Agent job? -

in ssms there way export list of job steps in sql server agent job?

the reason i'm asking i've been asked organize long list of job steps placed in 3 different jobs. i'd share team in excel document can create notes, demonstrate grouping , sorting ideas, argue it, etc.

is there way can export list, or @ to the lowest degree print it? screenshot, except list extends past screen? i'm not looking forwards keying hand excel.

thank ideas.

you can query server;

select job.name, steps.step_id, steps.step_name, steps.command msdb.dbo.sysjobs job inner bring together msdb.dbo.sysjobsteps steps on steps.job_id = job.job_id job.enabled = 1 order 1, 2

tsql ssms

No comments:

Post a Comment