December 27, 2010 at 10:40 am
I have setup a few maintenance plans in SSMS to perform backups. The backups are running fine but i am having 2 issues with notification.
1. I have setup Different Notify Operator Tasks for success and failure. I get the message (except on case), but I also get a detailed completion report like below. How do I disable this report from being sent? I not really sure how/where I enabled it.
"Microsoft(R) Server Maintenance Utility (Unicode) Version 10.0.1600 Report was generated on "GEORGE".
Maintenance Plan: IntraDay_Logs
Duration: 00:00:02
Status: Succeeded.
Details:
Back Up Database (Transaction Log) (GEORGE) Backup Database on Local server connection
Databases: CIMAEnMinLtd,Phoenix,PPPCo,PPPCo_Fileroom,ReportServer
Type: Transaction Log
Append existing
Task start: 2010-12-22T08:11:10.
How do I disable the "...
2. One of my Maintenance Plans only sends failure notices not success notices. Where do I debug this issue?
Thanks
Preview #1038271
December 27, 2010 at 11:27 am
Are you setting up the e-mails inside the plans, or in the jobs? I set that kind of thing up in the job, and it does what you'd expect.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 27, 2010 at 1:20 pm
I set it all up in the Maintenance Plan. Nothing at the job level. Have 4 plans. Some work fine, one does not.
December 27, 2010 at 5:17 pm
When you setup a maintenance plan - by default, reporting is enabled. You get to this reporting by clicking on the Reporting & Logging button next to the Manage Connections button on the toolbar.
In that dialog, you have the options of generating a text file and/or send report to an email recipient.
Check there to make sure you have that turned off - since you are going to control notifications through your notify operator tasks. This is where you are getting the detailed report from.
In your maintenance plans - you have to setup these tasks correctly if they are connected to multiple tasks. For example, if you have a single notify operator task which should notify you if any step fails - then you cannot have a solid red line connecting that task to all of the other tasks. When you have a solid red line - that means all tasks would have to fail for the notify operator task to be invoked.
To change this, modify the precedence constraint between one of the tasks and the notify operator task. At the bottom, there is an option for Multiple Constraints - with two options:
Logical AND, All constraints must evaluate to true
Logical OR, One constraint must evaluate to true
Change it from the first entry (Logical AND) to the second one (Logical OR). Now, if any one task in your plan fails, the notify operator task will execute.
For your notify operator task for successful completion - this should be the last task tied in the plan, and should be tied to the previous task with a success constraint (solid green line).
I hope this helps...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 28, 2010 at 6:25 am
Thanks. I believe that solves my issues.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply