Re: SQLSERVERAGENT service hung on starting

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: SalamElias (eliassal_at_online.nospam)
Date: 10/10/04

  • Next message: Arnie: "RE: Popup message" 
    Date: Sun, 10 Oct 2004 03:09:02 -0700

    Thanks for your response
    All of sudden, after 4 restarts, (booting) I managed to make it start and
    runing.
    For the first reason, I confirm that the account user is inthe admin local
    group.
    For the second reason, I havn't set up a MAPI profil in the mail session,
    however, every time I re-start the sql server agent, in it's error log I get
    the 2 following warnings :
    A - [260] Unable to start mail session (reason: No mail profile defined).
    trying to access a oulook express mailaccount
    B - [396] An idle CPU condition has not been defined - OnIdle job schedules
    will have no effect

    Thanks for any help

    "Dejan Sarka" wrote:

    > > "SQLSERVERAGENT service hung on starting".
    >
    > Couple of possible reasons include problem with Agent not having enough
    > permissions to read the registry keys it needs and possible problem with
    > mail profile.
    > Check whether the Windows account Agent uses is a member of the local
    > Administators group.
    > Set the Agent to not start automatically, and then restart your server.
    > Your SQL Server Agent will now be stopped instead of stuck in starting mode.
    > Remove the email setup for the SQL Server Agent and try to start it.
    >
    > --
    > Dejan Sarka, SQL Server MVP
    > Associate Mentor
    > Solid Quality Learning
    > More than just Training
    > www.SolidQualityLearning.com
    >
    >
    >
    >

  • Next message: Arnie: "RE: Popup message"