Skip to content

Instantly share code, notes, and snippets.

@sneakymonk3y

sneakymonk3y/gist:d8c0dee3a5824fedb4fc520aeeecebf5

Created August 3, 2021 19:16
Show Gist options
  • Save sneakymonk3y/d8c0dee3a5824fedb4fc520aeeecebf5 to your computer and use it in GitHub Desktop.
Save sneakymonk3y/d8c0dee3a5824fedb4fc520aeeecebf5 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. sneakymonk3y created this gist Aug 3, 2021.
    19 changes: 19 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,19 @@
    SELECT job.job_id as [JOB_ID],
    job.name as [JOB_NAME],
    job.description as [JOB_DESCRIPTION],
    steps.step_name,
    steps.subsystem,
    steps.command,
    SUSER_SNAME(job.owner_sid) as [JOB_OWNER],
    steps.proxy_id,
    proxies.name as [proxy_account],
    job.enabled,
    steps.server,
    job.date_created,
    steps.last_run_date
    FROM [msdb].[dbo].[sysjobs] job
    INNER JOIN [msdb].[dbo].[sysjobsteps] steps
    ON job.job_id = steps.job_id
    left join [msdb].[dbo].[sysproxies] proxies
    ON steps.proxy_id = proxies.proxy_id
    ORDER BY JOB_NAME, step_name