Shared Flashcard Set

Details

DBA, Chapter 10
Automating SQL Server
17
Computer Science
Undergraduate 4
03/22/2011

Additional Computer Science Flashcards

 


 

Cards

Term
SQL Server Agent
Definition
the scheduling engine for SQL Server
Term
Job
Definition
an execution container that can contain one or more steps in a process to be executed
Term
Job Steps
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
Control Flow Options
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
job schedule properties
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
one time scheduled jobs
Definition
run once and then never run again
Term
Recurring Scheduled Jobs
Definition
runs on a regular schedule
Term
Startup Scheduled Jobs
Definition
Run on startup every time the SQL Server Agent Starts
Term
Idle Scheduled Jobs
Definition
wait for CPU to become idle and then launch
Term
Job History File
Definition
job log file that allows you to review the job's outcome
Term
operator
Definition
an alias for a person, group or device
used to send info in the event of a failure or an alert.
Term
Three Types of Alert
Definition
SQL Server event
Performance Condition Alert
Windows Management Instrumentation (WMI) event
Term
SQL Server Event Alert
Definition
raised based on an error number or an error severity level
Term
Performance Condition Alert
Definition
defined against the System Monitor Counters
Term
WMI event alert
Definition
send alerts based on events on the server hosting the instance
Supporting users have an ad free experience!