Post reply

Launch sqlagent.exe

  • February 25, 2006 at 11:15 am

    #170805

    Does anyone knows why when I start the SQL Server Agent, it launchs a ms-dos windows with the sqlagent.exe..

     

    If I close that windows it stops the service too, can I disable that.???

    thanks

     

     

  • February 25, 2006 at 11:22 am

    #623357

    That's odd.

    How do you start sql server agent? From services.msc ?

    What sql server version are you using?

    Does the path in services.msc ->services-> SQLSERVERAGENT path to executable is correct?

    Mine is sql 2000:

    c:\Program Files\Microsoft SQL Server\MSSQL\binn\sqlagent.exe -i MSSQLSERVER

  • February 25, 2006 at 2:48 pm

    #623360

    I start the Sql server agent from the sql server sercvice manager, and if I start it from the services.msc it does the same thing, opens an msdos window, I can work ok while I keep that window open, but I dont know why do I have to do that,

     

    the path in the services.msc is

    C:\PROGRA~1\MICROS~2\MSSQL\binn\sqlagent.exe

    and I can't change it, do you  know how can I do that??

    I don't know if keeping the path in ms-dos format(with the "~") causes the problem

     

    well Im gonna keep trying, and any help is well accepted

    thanks

     

     

  • February 26, 2006 at 11:29 am

    #623375

    Try

    You need to check the configuration for the service. Go to

    Services(from Control Panel or Administrative Tools -

    depending on your OS).

    Go to the sqlserveragent service and view the properties for

    the service. Select the LogOn tab and make sure to uncheck

    the "Allow service to interact with desktop" checkbox.

    http://www.mcse.ms/archive85-2004-6-795590.html

  • February 26, 2006 at 3:13 pm

    #623379

    Problem solved, thanks to Jo Pattyn for the tip

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply