How can I tell if my SQL Server Agent is running without using the EM? The
network admins have control of the server in such a way as to not let the DB
A
start or stop the service on the server. This of course does not light up
the indicator in the EM for the Agent.Hi
If you run sp_who2 or query sysprocesses, you will see connections from
Agent. They are always there as they poll for jobs.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:D060BCE2-BE0D-493A-81FD-C0E7E18C9E15@.microsoft.com...
> How can I tell if my SQL Server Agent is running without using the EM?
> The
> network admins have control of the server in such a way as to not let the
> DBA
> start or stop the service on the server. This of course does not light up
> the indicator in the EM for the Agent.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment