Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
montu
Yak Posting Veteran
60 Posts |
 Posted - 2008-01-09 : 22:19:44
|
| Hi all is any one aware what this error means. one of my server restart every now and then(application issue). when server restart following message appears for SQL Agent not in error log.what is the reason behindMessage[425] delay_between_response attribute (10 sec) of alert (9) is less than poll interval for this alert (20 sec) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 22:43:53
|
| Did sql agent start? |
 |
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-09 : 22:52:32
|
| yes it restart when server restart |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:10:02
|
| Seems you have alert with delay_between_response set to 10 seconds and poll interval set to 20 seconds. The DelayBetweenResponses property represents the number of seconds SQL Server Agent waits before it generates another response for an alert. |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-09 : 23:34:55
|
| do u have any idea how and from where i can change it. thanks in advance |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-09 : 23:42:22
|
| Check sql agent -> alerts in ssms. |
|
|
|
DBADave
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-01-14 : 12:26:47
|
| I'm getting the same messages this morning. It happened after I restored MSDB using a backup from another server. In your case did you restore MSDB from another instance?Dave |
|
|
|
montu
Yak Posting Veteran
60 Posts |
Posted - 2008-01-14 : 18:08:48
|
| No, i got these errors when my server restart otherwise i never got these errors. |
|
|
|
|
|
|
Error for SQL Agent