how to know if the sqlagent is started - TechRepublic
TechRepublic | Forums | Web Development
Web Development
General discussion
February 9, 2003 at 05:05 PM
#2301172
rene_chapuis

how to know if the sqlagent is started

by rene_chapuis . Updated 22 years, 6 months ago

There is a procedure ‘ xp_sqlagent_is_started’ which makes it possible to know to it agent sql is started.
but the returns value is always 0 , whatever the state of the agent. Why ?

This discussion is locked

All Comments