0

I setup database mail, created an operator today and enable notify operator when job failed.

Is that all or do I need to create an alert too?

My boss just needs emails if any job failed.

Also how to test it to see it will work in the future?

Thanks

marc_s
  • 9,052
  • 6
  • 46
  • 52
Alexis Mineros
  • 29
  • 1
  • 5

1 Answers1

1

Regarding the status of job run, that's the correct steps.

However, its recommended you configure the alerts for any database corruption, HW/SW failures or any other cause for an outage. Read here to configure the same.

In order to test, create a TEST job and purposefully make it fail and see if you receive the failure notification email or not.

Md Haidar Ali Khan
  • 6,523
  • 9
  • 40
  • 62
KASQLDBA
  • 7,203
  • 6
  • 30
  • 53