Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
In addition to any logging confi gured for a job step, each time a job executes, SQL Server logs information into the _______ table in the msdb database
|
dbo.sysjobhistory
|
|
|
_________are used to send notifi cations when jobs fail or an alert is generated
|
Operators
|
|
|
If a job fails, where can you look to diagnose the problem?
|
- job history
- log files - windows event logs |
|
|
What types of job steps can be executed?
|
-T-SQL
-ActiveX scripts -operating system commands -executable files |
|
|
An ________ is an alias for a person, group, or device to which you want to be the target of notifications.
|
operator
|
|
|
Alerts can be confi gured as one of the following three types:
|
- SQL Server event
- Performance Condition alert - Windows Management Instrumentation (WMI) event |
|
|
What are the three types of alerts that can be created?
|
You can create alerts on performance counters, SQL Server errors, and WMI queries.
|
|
|
What are the two response actions that can be configured for an alert?
|
You can have an alert send a notification or execute a job in response to the alert condition.
|
|
|
_______ provides a scheduling engine that can be used to execute jobs.
|
SQL Server Agent
|
|
|
______ can have one or more steps with basic control fl ow dependencies, logging, notifi cation, and one or more execution schedules
|
Jobs
|
|
|
_________ are used to encapsulate the settings used to send a notification to a person, group, or device
|
Operators
|
