|
Home > Archive > microsoft.public.sqlserver.server > December 2002 > SQL Server Agent Timed Out
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Server Agent Timed Out
|
|
| Cliff 2002-12-20, 11:23 am |
| I have had a problem crop up a few times here that I do not understand,
running SQL Server 2000 in a fail-over cluster environment:
- A scheduled job does not complete, and when I look at the status, it says
"performing completion actions"
- I try to cancel the job, but it seems as though nothing happens.
- I try to stop SQL Server Agent
- Errors are generated in the System Event Log, starting with "SQL Server
Agent timed out." This not only causes SQL Server to stop, but causes a
fail-over to the other cluster node.
This has happened only a few times, it is sporadic and neither predictable
nor reproducable. I search the KnowledgeBase for "Agent timed out" and get
no hits.
Any ideas? Thanks.
| |
| Geoff N. Hiten 2002-12-20, 12:23 pm |
| Are you using SQL Agent mail for completion/success/failure notification?
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Cliff" <koehlc@psc.state.wi.us> wrote in message
news:OF5cOjEqCHA.1612@TK2MSFTNGP09...
> I have had a problem crop up a few times here that I do not understand,
> running SQL Server 2000 in a fail-over cluster environment:
> - A scheduled job does not complete, and when I look at the status, it
says
> "performing completion actions"
> - I try to cancel the job, but it seems as though nothing happens.
> - I try to stop SQL Server Agent
> - Errors are generated in the System Event Log, starting with "SQL Server
> Agent timed out." This not only causes SQL Server to stop, but causes a
> fail-over to the other cluster node.
>
> This has happened only a few times, it is sporadic and neither predictable
> nor reproducable. I search the KnowledgeBase for "Agent timed out" and
get
> no hits.
>
> Any ideas? Thanks.
>
>
| |
|
| Yes and No. If the job fails, we use the SQL Agent mail notification.
Internal to the job, if it succeeds, it generates mail using Outlook CDONTS.
It used to use xp_sendmail, but that caused lots of problems, which was why
it was converted to CDONTS.
"Geoff N. Hiten" <Geoff.Hiten@careerbuilder.com> wrote in message
news:OxPyM3EqCHA.2008@TK2MSFTNGP12...
> Are you using SQL Agent mail for completion/success/failure notification?
>
> --
> Geoff N. Hiten
> Senior Database Administrator
> Careerbuilder.com
>
>
> "Cliff" <koehlc@psc.state.wi.us> wrote in message
> news:OF5cOjEqCHA.1612@TK2MSFTNGP09...
> > I have had a problem crop up a few times here that I do not understand,
> > running SQL Server 2000 in a fail-over cluster environment:
> > - A scheduled job does not complete, and when I look at the status, it
> says
> > "performing completion actions"
> > - I try to cancel the job, but it seems as though nothing happens.
> > - I try to stop SQL Server Agent
> > - Errors are generated in the System Event Log, starting with "SQL
Server
> > Agent timed out." This not only causes SQL Server to stop, but causes a
> > fail-over to the other cluster node.
> >
> > This has happened only a few times, it is sporadic and neither
predictable
> > nor reproducable. I search the KnowledgeBase for "Agent timed out" and
> get
> > no hits.
> >
> > Any ideas? Thanks.
> >
> >
>
>
| |
| Geoff N. Hiten 2002-12-20, 1:23 pm |
| SQL Mail (and SQL Agent Mail) use MAPI, which is not all that good in
general and really blows chunks in a cluster environment. Try this:
http://www.sqldev.net/xp/xpsmtp.htm
My guess is that the SQL Agent is hanging trying to send a notification.
--
Geoff N. Hiten
Senior Database Administrator
Careerbuilder.com
"Cliff" <koehlc@psc.state.wi.us> wrote in message
news:#sRaxWFqCHA.2620@TK2MSFTNGP12...
> Yes and No. If the job fails, we use the SQL Agent mail notification.
> Internal to the job, if it succeeds, it generates mail using Outlook
CDONTS.
> It used to use xp_sendmail, but that caused lots of problems, which was
why
> it was converted to CDONTS.
>
>
> "Geoff N. Hiten" <Geoff.Hiten@careerbuilder.com> wrote in message
> news:OxPyM3EqCHA.2008@TK2MSFTNGP12...
> > Are you using SQL Agent mail for completion/success/failure
notification?
> >
> > --
> > Geoff N. Hiten
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> > "Cliff" <koehlc@psc.state.wi.us> wrote in message
> > news:OF5cOjEqCHA.1612@TK2MSFTNGP09...
> > > I have had a problem crop up a few times here that I do not
understand,
> > > running SQL Server 2000 in a fail-over cluster environment:
> > > - A scheduled job does not complete, and when I look at the status,
it
> > says
> > > "performing completion actions"
> > > - I try to cancel the job, but it seems as though nothing happens.
> > > - I try to stop SQL Server Agent
> > > - Errors are generated in the System Event Log, starting with "SQL
> Server
> > > Agent timed out." This not only causes SQL Server to stop, but causes
a[col
or=darkred]
> > > fail-over to the other cluster node.
> > >
> > > This has happened only a few times, it is sporadic and neither
> predictable[color
=darkred]
> > > nor reproducable. I search the KnowledgeBase for "Agent timed out"[/color][/color]
and
> > get
> > > no hits.
> > >
> > > Any ideas? Thanks.
> > >
> > >
> >
> >
>
>
|
|
|
|
|