• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/15

Click to flip

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(?).