you need to enable the server as a distributor. I believe you have not done so, right?

OK sorry about that. Let's go step by step.

Alerts are fired if the message in sysmessages is "logged"

The Alert Engine checks for...

What you got are "WARNINGS" nothing to do with "ERRORS".

This tend to happen on jobs that were re-ordered or modified at some point but is usually not an issue.

I think that...

This looks like a "data" problem to me.

avipenina (6/12/2008)

---

Hi,

if i setup alert in SQL Server Agent for lets say severity 24,when i query the sys.messages for severity = 24, i see that there are 9 rows with...

Maybe the join was spooling a large amount of data to tempdb ?

Did you check the execution plan ?

Jeff Moden (6/12/2008)

---

Lynn Pettis (6/12/2008)

---

Jeff Moden (6/12/2008)

---

Not sure the use of a correlated subquery (a form of hidden RBAR) will speed anything up here... Maybe...

The real fact of the...

You must check the locks on the distribution database or on the Server in general. Too many locks can make that stored procedure time-out!

TheSQLGuru (6/11/2008)

---

Peso (6/10/2008)

---

You...

I would also vote for the use of a calendar table but just for the fun of it:

declare @mindate datetime, @maxdate datetime

select @mindate = left(convert(char(10),dateadd(m,-2,getdate()),112),6) + '01'

select @maxdate =...

I don't quite understand how you determined that "order". Can you be more specific ?

happy to help 🙂

If Autoshrink is "ON" and you tried to run a "dbcc shrinkfile" you could get that message.

In case you want to keep track of what's going on:

http://support.microsoft.com/kb/937137