List two events in which the SQL Server Agent should be used to send notifications and alerts?

What will be an ideal response?


SQL Server Agent job failure notifications
SQL Server errors with a severity level of 17 and above
Deadlocks
Resource alerts that include high CPU or memory utilization and disk space shortage

Computer Science & Information Technology

You might also like to view...

Which of the following is false?

a. A string can be defined to store any data type. b. Class string provides bounds checking in its member function at. c. Class string’s overloaded [] operator returns a vector element as an rvalue or an lvalue, depending on the context. d. An exception is thrown if the argument to string’s at member function is an invalid subscript.

Computer Science & Information Technology

The individual words you use as search terms when using a search engine are referred to as ________

A) wildcards B) keywords C) hits D) queries

Computer Science & Information Technology

A presentation effect is a set of unified design elements that provides a unique look for your presentation

Indicate whether the statement is true or false

Computer Science & Information Technology

What is a good response time on a LAN for the ping utility?

A. 1 ms B. 100 ms C. 1 Kb D. 10 Kb

Computer Science & Information Technology