MS SQL DBA Tools - SQL Server Agent Manager

Provides manageability for the SQL Server Agent. This includes operators, jobs and alerts.



 

Toolbar Operations - Depending on the Tab selected, there are different Toolbar Operations available.

Available Operations for Alerts tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Create Alert: Creates a new alert
Alter Alert: Edits selected alert
Drop Alert: Drops selected alert
Alert Properties: Shows the properties of selected alert

Available Operations for Operators tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Create Operator: Creates a new operator
Alter Operator: Edits selected operator
Drop Operator: Drops selected operator
Operator Properties: Shows properties of selected operator

Available Operations for Jobs tab
Refresh: Refreshes all tabs in the storage manager from the database
Reconnect: Reconnects to the database server
Copy all w/ Headers and Row counts: Copies every data from the tab selected to paste the information anywhere else needed
Create Job: Creates a new job
Alter Job: Edits selected job
Drop Job: Drops selected job
Job Properties: Shows properties of selected job
Start Job: Starts selected job
Stop Job: Stops selected job
Enable Job: Enables selected job
Disable Job: Disables selected job
Job History: Shows history for selected job

Alerts Tab - Provides a list of alerts and detailed information on each alert.

Name: Alert name
Enabled: Whether the alert is enabled
Error: Error number
Severity: Severity code number
Last Occured: Last occurence date
Email: Whether to notify the operator by email
Pager: Whether to notify the operator using pager
Net Send: Whether to notify the operator using network popup
Count: Occurence count

Operators Tab - Provides a list of operators and detailed information on each operator.

Name: Operator name
Enabled: Whether the operator is enabled
Last Email: Last email notification date
Last Page: Last pager notification date
Last Net Send: Last notification over network popup

Jobs Tab - Provides a list of jobs and detailed information on each job.

Name: Job Name
Category: Job category name
Enabled: Whether the job is enabled
Scheduled: Whether the job is scheduled
Status: Current execution status
Last Run Status (Start Date) Outcome of the job the last time it ran (Failed, Succeeded, Canceled, Unknown) and the job start date
Next Run Date: Date the job is scheduled to run next



  • No labels