Re: SqlServerAgent : error 393 on sql2k

From: iKc (pruello@tibco.fr)
Date: 08/01/02 

From: "iKc" <pruello@tibco.fr>
Date: Thu, 1 Aug 2002 09:22:58 +0200

Thks.
I didn't tried your solution as I put the sql2k sp2 on my server and it
works fine now(sql was in RTM). I keep your solution in the case of.....
Cya
"Sue Hoegemeier" <Sue_H@nomail.please> a écrit dans le message de news:
2v7gku023an9kji2725q4qmc5h2cvl858b@4ax.com...
> 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
> >
> >
>

Relevant Pages

  • Re: Replication between 2 SBS (small business server) Trusts
    ... Am i wrong to assume that data flows from a server ... Incoming Port: 1433 ... replication agent) so i removed replication and attempted to start from ... sql Agent Password: agt@Rep ...
    (microsoft.public.sqlserver.replication)
  • Re: Error 22022: Problems with email
    ... I have decided to wait until the email server is upgraded to Exchange 2003, ... make sure your SQL Agent account and SQL Server start-up account are ... Try to create a new mail profile associating to SQL Agent Mail and try ...
    (microsoft.public.sqlserver.server)
  • Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
    ... > And in what DB role on SQL Server is domain\user1? ... > www.SQLDTS.com - The site for all your DTS needs. ... >> Successful DTS package fails when scheduled as a SQL Agent job. ... >> between Agent and DTS security context as far as Access is concerned? ...
    (microsoft.public.sqlserver.dts)
  • Re: dts vs. job
    ... The problem is probably the context that DTS is executing under. ... to remember is that DTS is a client process, ... Now, when you run it as a SQL Agent job, it will run either as the SQL ... Server service account or if the job is not ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Agent - Mail Profile - Outlook
    ... SQL Agent will have Outlook open, so Outlook has it's files open. ... get your mail off the server. ... > I setup an operator, and then the mail profile for the SQL Agent, I have ...
    (microsoft.public.sqlserver.programming)