Very Computer

my job file and i get this message

 Unable to post notification to SQLServerAgent
(reason: The maximum number of pending SQLServerAgent notifications has been
exceeded.
 The notification will be ignored.) [SQLSTATE 42000] (Error 22022)
 Associated statement is not prepared [SQLSTATE HY007] (Error 0)
 Unable to post notification to SQLServerAgent
(reason: The maximum number of pending SQLServerAgent notifications has been
exceeded.
 The notification will be ignored.) [SQLSTATE 42000] (Error 22022)

but their is no notification in this job

thank
shmulik

I haven't seen that myself, but I dug this previous thread
out of the archive which you might find useful:

http://tinyurl.com/c744

HTH

Regards,
Greg Linwood
SQL Server MVP

Quote:>-----Original Message-----
>hi all

>my job file and i get this message

> Unable to post notification to SQLServerAgent
>(reason: The maximum number of pending SQLServerAgent

Quote:>exceeded.
> The notification will be ignored.) [SQLSTATE 42000]
(Error 22022)
> Associated statement is not prepared [SQLSTATE HY007]
(Error 0)
> Unable to post notification to SQLServerAgent
>(reason: The maximum number of pending SQLServerAgent

Quote:>exceeded.
> The notification will be ignored.) [SQLSTATE 42000]
(Error 22022)

>but their is no notification in this job

>thank
>shmulik

>.