x
login about faq Site discussion (meta-askssc)

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

Chitra
148 10 15 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 ♦♦
38.8k 55 69 104

(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

Tim
31.5k 20 30 116

(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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1834
x170
x19

asked: Dec 17 '10 at 11:20 AM

Seen: 570 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.