Aged Yak Warrior
Posted - 05/21/2014 : 09:52:11
I am trying to figure this out, and need your help.
In this case, SQL agent sends email notification to me when it should not.
In SQL 2012 enterprise, I created this update stats maintenance plan job from SSMS.
First, I have set it up to send notification when complete.
Then, I changed it to notify when it failed.
However, I am still receiving emails even it succeeded.
Even after I removed the notification all together and restart the agent, the email still faithfully arrive!
I saw it in here
select * from dbo.sysmaintplan_plans pln
join dbo.sysmaintplan_subplans spln on pln.id = spln.plan_id
join dbo.sysjobs job on spln.job_id = job.job_id
where pln.name ='Update statistics'
Select * FROM [dbo].[sysmail_mailitems]
As you can tell, it is not a major issue, but it bothers me in a production box, that it acts the way it is not supposed to.
I understand some of you have said maintenance plan is not good in many regards.