Can you tell me if I can insert more than one "E-mail Name" on the "Notification Options" on one Operator? (min 3:13) And can I use more than one Database mail Account/Profile to send notifications into diferent Jobs ? (min 2:23)
Hi Techbrothers, thanks for this video. I have a question, can we customize the message in the job failure notification message as per our need? because right now I am getting job failure but it is the default one as follows: __________________________________________________________________________ JOB RUN: 'Disk alert' was run on 1/27/2017 at 10:35:31 AM DURATION: 0 hours, 0 minutes, 3 seconds STATUS: Succeeded MESSAGES: The job succeeded. The Job was invoked by User sa. The last step to run was step 1 (Disk alert). _________________________________________________________________________ I am talking about the last line. thank you in advance.
Hi, Is there a way to include more detailed description of the failure in the email notification. I am using it to notify SSIS job failure. In that case, is it possible to send email with information about the failed SSIS component?
My requirement is without adding as a second step , i need to send a email notification when job fails by using operator. Pls Provide the Script for that. Help me out of this.
sir i have configured as per your video after the job execution manually we execute the script it will send the mail with attachment but if try under a job create a notification email it will not sending any emails we are getting kind of below erro Failed to open attachment file 'D:\SQL_JOBS_NOTIFICATION_SUCCESS\test.txt'. Executing API 'CreateFile' failed with errror no 32 kindly suggest me
Please be sure that file is created already in previous step, also sql server agent and engine account has all permissions on the folder/folders that you have mentioned. From your error it seems like File doesn’t exist for it to pick up. You can monitor it live by opening folder on one side and running job or script on other side (Side by side)
Good, clear and to the point! Really like your videos!
+RIDDLE0MASTER Thanks dear!
Can you tell me if I can insert more than one "E-mail Name" on the "Notification Options" on one Operator? (min 3:13)
And can I use more than one Database mail Account/Profile to send notifications into diferent Jobs ? (min 2:23)
Hi Techbrothers, thanks for this video.
I have a question, can we customize the message in the job failure notification message as per our need? because right now I am getting job failure but it is the default one as follows:
__________________________________________________________________________
JOB RUN: 'Disk alert' was run on 1/27/2017 at 10:35:31 AM
DURATION: 0 hours, 0 minutes, 3 seconds
STATUS: Succeeded
MESSAGES: The job succeeded. The Job was invoked by User sa. The last step to run was step 1 (Disk alert).
_________________________________________________________________________
I am talking about the last line. thank you in advance.
Extremely well done tutorial video - Thank you!
Thank you:)
Hi, Is there a way to include more detailed description of the failure in the email notification. I am using it to notify SSIS job failure. In that case, is it possible to send email with information about the failed SSIS component?
Would be great if you give video link of operator on top right corner or description
My requirement is without adding as a second step , i need to send a email notification when job fails by using operator. Pls Provide the Script for that. Help me out of this.
sir i have configured as per your video after the job execution manually we execute the script
it will send the mail with attachment but if try under a job create a notification email
it will not sending any emails we are getting kind of below erro
Failed to open attachment file 'D:\SQL_JOBS_NOTIFICATION_SUCCESS\test.txt'.
Executing API 'CreateFile' failed with errror no 32
kindly suggest me
Please be sure that file is created already in previous step, also sql server agent and engine account has all permissions on the folder/folders that you have mentioned. From your error it seems like File doesn’t exist for it to pick up. You can monitor it live by opening folder on one side and running job or script on other side (Side by side)
Thank you so much ♥
Really helpful video, keep it up.
Thanks!!!!!!!!!!!!!!!!!!!!!!!! =)
You are most welcome:)
√√√