none
SQL server agent- agent Xps disabled

    Question

  •  

    Hi,

    I m SQl server my SQl server agent shows:

     

    agent Xps disabled- i cant even restart it.

    what does that means?

    Thursday, June 19, 2008 11:47 PM

Answers

  • Ok no errors reported in sql agent log, can you try executing the below query and then try starting agent service.

     

    Code Snippet

    sp_configure 'show advanced options',1

    go

    reconfigure with override

    go

    sp_configure 'Agent XPs',1

    go

    reconfigure with override

    go

    sp_configure 'show advanced options',0

    go

    reconfigure with override

    go

     

     

    Friday, June 20, 2008 12:36 AM
    Moderator

All replies

  • Hi,

     

    What is the error message you are getting while start SQL Agent??? Can you post SQLAgent.out file content??

     

    You can refer the link below to enable Agent XP's and then try starting sql agent service.

    http://sqlserver-qa.net/blogs/tools/archive/2008/02/06/agent-xps-disabled-error-how-to-resolve-and-restart-sql-server-agent-without-any-error.aspx

    Thursday, June 19, 2008 11:54 PM
    Moderator
  •  

    Take a look at sqlagent log. It should tell you why your agent cannot be started.
    Thursday, June 19, 2008 11:54 PM
    Moderator
  • when i right click on it, it just has reports and refresh option enabled.

    Friday, June 20, 2008 12:00 AM
  • Manoj,

     

    Search for SQLAgent.out file content which is nothing but SQLAgent log.

    Friday, June 20, 2008 12:02 AM
    Moderator
  • It displays

     

     

    2008-06-20 11:41:18 - ? [100] Microsoft SQLServerAgent version 9.00.1399.06 (x86 unicode retail build) : Process ID 772
    2008-06-20 11:41:18 - ? [101] SQL Server Server\NamedInstance version 9.00.1399 (0 connection limit)
    2008-06-20 11:41:18 - ? [102] SQL Server ODBC driver version 9.00.3042
    2008-06-20 11:41:18 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is Server\NamedInstance
    2008-06-20 11:41:18 - ? [310] 2 processor(s) and 2018 MB RAM detected
    2008-06-20 11:41:18 - ? [339] Local computer is mycomputer running Windows NT 6.0 (6000)
    2008-06-20 11:41:18 - ? [432] There are 11 subsystems in the subsystems cache
    2008-06-20 11:41:19 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
    2008-06-20 11:41:19 - ? [129] SQLAgent$NamedInstance starting under Windows NT service control
    2008-06-20 11:41:19 - + [260] Unable to start mail session (reason: No mail profile defined)
    2008-06-20 11:41:19 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

     

    Friday, June 20, 2008 12:09 AM
  • Ok no errors reported in sql agent log, can you try executing the below query and then try starting agent service.

     

    Code Snippet

    sp_configure 'show advanced options',1

    go

    reconfigure with override

    go

    sp_configure 'Agent XPs',1

    go

    reconfigure with override

    go

    sp_configure 'show advanced options',0

    go

    reconfigure with override

    go

     

     

    Friday, June 20, 2008 12:36 AM
    Moderator
  • k

    that removed the disable XP quote form agent.

    when i try to restart it, it shows access denied.

    i m admin at my pc

     

    Friday, June 20, 2008 1:06 AM
  • I hv fixed the access denied

    Thanks

    all good

     

    Friday, June 20, 2008 1:10 AM
  • I still dont understand why 'Agent XPs' was disabled

    Friday, June 20, 2008 1:11 AM
  • Sunday, December 16, 2012 12:27 AM
  • Helpful psot
    Friday, October 25, 2013 7:04 AM