SQL Server Science
Technical Articles for the DBA / Developer
Home » sql agent

SQL Server Agent Job Activity

2018-04-10 · by Hannah Vernon · in SQL Server Agent, t-sql, tools

SQL Server Agent provides a graphical user interface to inspect the status of agent jobs. The Job Activity Monitor looks like: However, if you want to programmatically obtain the detail about running jobs, including details…

Tool for scripting SQL Server Agent Jobs

2015-06-09 · by Hannah Vernon · in tools

I recently created an open-source tool that will create a T-SQL script file containing code to recreate whatever jobs you presently have in SQL Server Agent for any given SQL Instance, up to SQL Server…

subscribe now for updates
Stay up-to-date with the latest posts as they happen!
* = required field
unsubscribe from list

Search

Categories

  • announcements
    • events
  • basics
    • localization
  • configuration
  • DMVs
  • documentation
  • extended-events
  • Internals
  • maintenance
    • patching
  • performance
  • recovery
  • reporting
  • security
    • data security
  • service broker
  • SQL Server Agent
  • statistics
  • sys
  • t-sql
    • xml
  • tools
    • data masking
  • troubleshooting
  • Uncategorized

Pages

  • About SQL Server Science
  • Cart
  • Checkout
  • Get Better Help with a Minimal, Complete, and Verifiable Example, or MCVE
  • My account
  • Privacy Policy
  • Shop

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2023 SQL Server Science