locked
SQl Server 2014 express edition unable to start SQL Agent job RRS feed

  • Question

  • Hi We have 2014 express edition and unable to start the agent job. 

    Agent error log says

    2019-11-04 11:38:03 - ? [100] Microsoft SQLServerAgent version 12.0.2000.8 (X64 unicode retail build) : Process ID 7068
    2019-11-04 11:38:03 - ? [495] The SQL Server Agent startup service account is PROD\BMSP01_sqlag.
    2019-11-04 11:38:03 - ? [393] Waiting for SQL Server to recover database 'msdb'...
    2019-11-04 11:38:03 - ? [000] Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'Agent XPs' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
    2019-11-04 11:38:03 - ? [101] SQL Server BMSP01 version 12.00.2000 (0 connection limit)
    2019-11-04 11:38:03 - ? [102] SQL Server ODBC driver version 11.00.2100
    2019-11-04 11:38:03 - ? [103] NetLib being used by driver is DBNETLIB; Local host server is 
    2019-11-04 11:38:03 - ? [310] 4 processor(s) and 16384 MB RAM detected
    2019-11-04 11:38:03 - ? [339] Local computer is BMSP01 running Windows NT 6.2 (9200) 
    2019-11-04 11:38:03 - ! [000] This installation of SQL Server Agent is disabled.  The edition of SQL Server that installed this service does not support SQL Server Agent.
    2019-11-04 11:38:03 - ? [000] Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)  Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
    2019-11-04 11:38:03 - ? [098] SQLServerAgent terminated (normally)

    ++++++++++++++++++++++++++

    Any one can help to start the agent? 

    Thanks 

    Udara

    Monday, November 4, 2019 12:57 AM

Answers

All replies