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...

The ________ file format is often used for animated images that appear on the web

A) GIF B) PPTX C) JPEG D) PDF

Computer Science & Information Technology

Develop a sequence diagram showing the interactions involved when a student registers for a course in a university. Courses may have limited enrolment, so the registration process must include checks that places are available. Assume that the student accesses an electronic course catalog to find out about available courses.

What will be an ideal response?

Computer Science & Information Technology