I have created a job named email and I have 3 steps in this job:
Step 1 is successful and the backup is created in E:\Backup\backup_filename
So my issue is step 1 is successful and it never proceeds to step 2 and 3 so it cannot send email. How do I solve this issues.
asked Feb 22, 2010 at 03:50 PM in Default
Look at the Job History. See if there are any failures reported. How do you know it goes to step 2? Try starting the job at Step 2 to confirm that there is not problem with the email step. Also look at the event view of that machine to see if anything pertinent was logged there.
answered Feb 22, 2010 at 04:40 PM
I can see that you had quite a lot of issues with this and even though this is an old post, I found myself in the same situation as you did, after having been through the same scenario of calling a stored procedure to send my notification e-mails.
After quite some time of trying to "fix" this error, although from my side I considered everything to be ok, I decided to look for alternatives.
After searching for quite a while I discovered that I can work around these errors I was getting by using some third party tools for managing my backup jobs. After using quite a number of online tools, I settled with one that allowed me to just set up my notifications for my backup tasks in less than 10 seconds and it has worked flawlessly ever since.
I am really happy with the tool I found and here's just a short snippet of how easy it is to get notified about the status of your job: http://sqlbak.com/blog/sql-server-backup-email-notification/
answered Sep 28, 2014 at 04:52 PM