SQL Server Agent Manager - Provides manageability for the SQL Server Agent. This includes operators, jobs and alerts.
|
Toolbar Operations -
Refresh : Will refresh all tabs in the server agent manager from the database
Create Alert: Create a new alert
Alter Alert: Edit selected alert
Drop Alert: Drop selected alert
Alert Properties: View properties of selected alert
Create Operator: Create a new operator
Alter Operator: Edit selected operator
Drop Operator: Drop selected operator
Operator Properties: View properties of selected operator
Create Job: Create a new job
Alter Job: Edit selected job
Drop Job: Drop selected job
Job Properties: View properties of selected job
Start Job: Start selected job
Stop Job: Stop selected job
Enable Job: Enable selected job
Disable Job: Disable selected job
Job History: Show 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
|
 |
