question

Chitra avatar image
Chitra asked

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
sql-server-2005backupdatabase-email
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tim avatar image
Tim answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
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.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.