• Maybe the question should have had the "on all SQL versions except EXPRESS" in there...

    If you call xp_servicecontrol on EXPRESS edition and get an error, that is NOT telling you if the agent is running or not, it is simply returning an error...

    Just my two penn'orth...

    Kelsey Thornton
    MBCS CITP