Term
|
Definition
| the scheduling engine for SQL Server |
|
|
Term
|
Definition
| an execution container that can contain one or more steps in a process to be executed |
|
|
Term
|
Definition
| The execution elements within a job |
|
|
Term
| what is the default security context for each job? |
|
Definition
| login set as the owner of the job |
|
|
Term
|
Definition
| can be specified based on either success or failure |
|
|
Term
| Control Flow Options, best practices |
|
Definition
• Each job step should be configured to log to a file
• Create a new log file in the first job step, and append information for each additional job step in the job |
|
|
Term
|
Definition
1. Frequency type
2. Recurrence within a frequency
3. Recurrence within a day on minute or hourly basis
4. Start and end date for the schedule to be valid |
|
|
Term
|
Definition
| run once and then never run again |
|
|
Term
|
Definition
| runs on a regular schedule |
|
|
Term
|
Definition
| Run on startup every time the SQL Server Agent Starts |
|
|
Term
|
Definition
| wait for CPU to become idle and then launch |
|
|
Term
|
Definition
| job log file that allows you to review the job's outcome |
|
|
Term
|
Definition
an alias for a person, group or device
used to send info in the event of a failure or an alert. |
|
|
Term
|
Definition
SQL Server event
Performance Condition Alert
Windows Management Instrumentation (WMI) event |
|
|
Term
|
Definition
| raised based on an error number or an error severity level |
|
|
Term
| Performance Condition Alert |
|
Definition
| defined against the System Monitor Counters |
|
|
Term
|
Definition
| send alerts based on events on the server hosting the instance |
|
|
