Re: SqlServerAgent : error 393 on sql2k

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Wed, 31 Jul 2002 11:52:08 -0600

I've seen posts on this problem before when lightweight
pooling was enabled. If you have it enabled, go back to the
default setting of 0 using sp_configure.
You need to restart the service for the setting to take
effect. For more info, see lightweight pooling in books
online.
I think you could also hit the problem is the mail profile
for SQL Agent is messed up. In that case, you could try
removing the mail profile from SQL Agent properties and
start up the service and see if that corrects the problem.

-Sue

On Wed, 31 Jul 2002 18:36:01 +0200, "iKc" <pruello@tibco.fr>
wrote:

>Hello,
>I've this error when I launch my sqlserveragent. "[393] Waiting for
>SQLServer restoring databses..." ([393] Attente de la récupération des bases
>de données par SQL Server... on my french server). Does anyone got an idea
>to solve this as my scheduled jobs don't work?
>Thanks
>
>