Hi DB Experts,
I am sending mail notification when some job fails, it is by the way of notification operators.
My first problem is i can not register multiple operators for mail notification, i have to create mail alias for that.
Second problem is when the mail notification is sent even if the job is failing in subject line i am getting job completed messege, so i want to customize the subject line and need to have the word 'failed' in subject line, i dont want to do this by sp_send_dbmail option.
Pls. let me know, its urgent.