Email Notification

I have the full and differential backup created which also sends email notification with the backup file name however when I added the transactional log I do not get the email notification of the transactional backup job.. I have used database mail and operators but no clue yet. Restarted the sqlserver Agent
more ▼

asked Dec 17 '10 at 11:20 AM in Default

Chitra gravatar image

148 14 17 19

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
how are you sending the email, as a step in the job using TSQL or as a setting in the job to email on completion? If its a step in the job then the logic between steps may be broken after you added a step, review the "On success go to" and "On failure go to" values in each step to make sure they will all flow the way you want them to.
more ▼

answered Dec 17 '10 at 04:27 PM

Fatherjack gravatar image

Fatherjack ♦♦
41.3k 73 77 107

(comments are locked)
10|1200 characters needed characters left
Most likely you have a second step in your full and differential backup job that sends the email. You may want to fully review those jobs and include the notification steps in your tlog job.
more ▼

answered Dec 17 '10 at 01:04 PM

Tim gravatar image

35.5k 32 41 138

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Dec 17 '10 at 11:20 AM

Seen: 800 times

Last Updated: Dec 21 '10 at 08:00 AM