December 14, 2010 at 12:37 pm
A job is attempting to run a job and email 110 people their output. However, it is getting this error:
Unable to post notification to SQLServerAgent (reason: The maximum number of pending SQLServerAgent notifications has been exceeded.
The only thing I can find is this KB article that says a workaround is to restart SQLServerAgent with no other fix.
http://support.microsoft.com/kb/921089
The article talks about jobs from Biztalk and we don't have that. We are running SQL 2005 SP3 on Win2003 cluster.
Any help would be appreciated.
December 14, 2010 at 2:22 pm
110 people? Have you tried having IT create an e-mail group? Or have you thought about posting data to an RSS feed?
- 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 14, 2010 at 2:25 pm
A table has all 110 email addresses. The report is run and logic allows an email to be sent to each person with only the employees that report under them. It is not just one big report that is emailed to everyone.
December 15, 2010 at 8:47 am
Okay. You may need to add some delays between alerts then. It looks like you're filling up the queue by calling it too many times in too short a time span.
- 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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply