June 25, 2008 at 8:49 am
We have a SQL 2005 clustered environment that has been in production for about 6 months. In SQL Agent we have several jobs that backup databases and one job that runs transaction log backups every 15 minutes for our critical DB. The jobs have always run fine.
Within each backup job there are 2 steps. The first step performs the backup of the DB. If that step succeeds, the "On Success Action" tells it to "Quit the Job Reporting Success". If the Backup step fails the "On Failure Action" tells it to go to Step 2 which is a database mail step that sends a message to the DBA group to notify that the job failed. This whole week, the backup step (Step 1) has succeeded for all of our backups. However, we have gotten the error message from Step 2 sent to us every time. When I look at the job history, it shows success for every run and it only shows that Step 1 has run. I checked all of the backups and they look fine. The log files that are created show success.
When I run one of the backup jobs manually, it DOES NOT send me the error message in Step 2 but every time it runs at the scheduled time I receive the message. This is getting annoying as the transaction log backup for the one critical DB runs every 15 minutes and even though it is succeeding I am getting the error message every 15 minutes.
I restarted the SQL Agent Services and that didn't fix the problem. I also re-created some of the jobs and that didn't fix anything either. Last weekend, Windows patches were applied to the server but I don't know if that would somehow cause this problem.
Very strange. Has anyone encountered anything similar? Thanks.
June 26, 2008 at 11:36 am
I have always used the Notifications on my jobs to send me a message when the job failed. It seems your setup should be working fine but I'm wondering why you don't go simpler and use the notifications function already built in?
June 26, 2008 at 11:52 am
I also would try switching to the built-in notifications function and see if that handles it better.
As far as a job going on to a step that doesn't apply, I haven't had that happen. Have you double-checked that nothing was changed in the handling of the steps in any of the jobs?
- 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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply