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;
15 Cards in this Set
- Front
- Back
Where is the Jobs creation node found in SSMS?
|
(Server) -> SQL Server Agent -> Jobs
|
|
What is the use of having a Job Owner?
|
Only serveradmin or the job owner can change/update a job: A non-admin owner needs proxy access for some changes.
|
|
Where are job schedules created?
|
In the New Jobs window, same as regular jobs.
|
|
What job scheduling options are there?
|
Time, CPU Idle conditions, SQL Server Agent startup, or once only.
|
|
Where is the Maintenance Plan Wizard in SSMS?
|
Management -> Maintenance Plans -> right-click
|
|
What tasks can the maintenance wizard set up?
|
Check Database Integrity
Shrink Database Reorganize or Rebuild Index Update Statistics Clean Up History (Maintenance backups/reports, job history) Execute SQL Server Agent Job or T-SQL statement Back up Database (Full, Differential, or Transaction log) Notify Operator |
|
How many schedules can be defined or used for a given maintenance plan?
|
Only one: You can't reuse the same schedule setup so easily.
|
|
What does the Maintenance Plan wizard actually create?
|
A single SSIS package to be executed at the given schedule via an agent job.
|
|
Where are the items created by a maintenance plan located?
|
The main SSIS package is put in the msdb database: Further detail is added to the corresponding sys.dbmaintplan* tables.
|
|
What sort of things CAN'T you do with the maintenance plan wizard?
|
Create or directly modify existing databases, call existing SSIS packages, or other trick questions. It's for backup and cleaning.
|
|
What's an operator?
|
A notification target for jobs to message. Probably when something goes wrong.
|
|
What notification methods are valid for an operator?
|
Net send, e-mail, or (phone/pager) text message.
NOT instant messaging or other extra-customized contact methods. |
|
What's an alert?
|
An item that monitors database conditions and responds to certain performance conditions, SQL Server events, or Windows Management Instrumentation events with automated reactions and/or notifications.
|
|
How many performance counters can an alert use?
|
Just one: If it's a complex check, alerts won't be enough.
|
|
What CAN'T Alerts track?
|
CPU utilization and other stats not available to SQL Server counters, security permission changes, or other non-performance internal changes(?).
|