May 28, 2014 at 9:03 pm
I'm running SQL Server 2005. I have about 100 SQL Jobs, most of them have been running for years. All of them are configured to send EMAILs on failure and they have been working fine up until yesterday at 4 PM. All of a sudden, every time a SQL job started it would trigger the 'failure EMAILs'. If I look at the job histories in SQL Agent I see all the jobs and all the job steps are successful. Somehow, the EMAIL is getting triggered but the jobs are not truely failing. I tried restarting SQL AGENT. I've run CHECKDB on Master and msdb. I've looked at the SQL Server log, the SQL Agent Log and the Windows Application and System logs... Nothing I can see... I'm completely stumped. Any ideas??? Please help, I'm getting swamped with EMAILs!!!
Here's an EMAIL, when I look at the Job Historyfor this job I see 1 successful job with 2 successful job steps.
JOB RUN:'MOS Job Notification' was run on 5/28/2014 at 10:30:00 PM
DURATION:0 hours, 0 minutes, 0 seconds
STATUS: Failed
MESSAGES:The job failed. The Job was invoked by Schedule 149 (Check MOS Report 4). The last step to run was step 1 (Check MOS_Phone_Stats for latest phone interval data).
Here is the job history that corresponds to the EMAIL above
05/28/2014 22:30:01,MOS Job Notification,Success,0,BOSDW01,MOS Job Notification,(Job outcome),,The job succeeded.
The Job was invoked by Schedule 149 (Check MOS Report 4).
The last step to run was step 2 (Check MOS_SR_Order_Stats_By_Interval for latest SR interval data).,00:00:10,0,0,,,,0
May 29, 2014 at 3:33 am
(dup)
May 29, 2014 at 3:33 am
Open up one of the jobs and go to the Notifications page.
Where it says E-mail does it say "When the job succeeds"?
May 29, 2014 at 3:52 am
It is blank...
Note that in the EMAIL that I'm getting from SQL Agent the STATUS = Failed...
JOB RUN: 'MOS Job Notification' was run on 5/28/2014 at 10:30:00 PM
DURATION: 0 hours, 0 minutes, 0 seconds
STATUS: Failed
MESSAGES: The job failed. The Job was invoked by Schedule 149 (Check MOS Report 4). The last step to run was step 1 (Check MOS_Phone_Stats for latest phone interval data).
May 29, 2014 at 4:03 am
Sorry, I should have clarified how the EMAIL notifications are set up.
The Checkbox next to EMAIL is checked, I've picked the Operator from the Operator drop-down (me) and the next drop down says 'When the job fails'.
Again, this has been the set for years and has worked correctly until yesterday.
May 29, 2014 at 4:45 am
Another piece of info...
Some of the jobs are set up to Page an operator when the job fails. Those pages are not happening when the job starts. So, somehow, when SQL Agent starts a job the EMAIL 'when the job fails' gets triggered, but the Page 'when the job fails' doesn't get triggered.
When the job truely fails, then the Page does get triggered.
May 29, 2014 at 6:43 am
Aha, I found the problem. Our tech team had cloned the server and restarted SQL AGENT on a new server. The job failures were actually coming from the new server.
May 29, 2014 at 9:27 am
😀 Argh!
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply