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