Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@sneakymonk3y

sneakymonk3y/gist:d8c0dee3a5824fedb4fc520aeeecebf5

Created August 3, 2021 19:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • 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
MSSQL Agents Jobs
Raw
gistfile1.txt
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
@sneakymonk3y
Copy link
Author

From https://www.slideshare.net/nullbind/beyond-xpcmdshell-owning-the-empire-through-sql-server

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment