With CFMX, is there a way to monitor when SQL Server Agent/Service
are stopped and stared?
Well, ideally, those services should be on a different machine entirely. In
that case, there wouldn't be anything within CF that would let you directly
query the status of those remote services. You could certainly build
something that would, however. For example, you could build a batch file
that uses Sysinternals' pstools to query the service status, assuming you
have an account that can authenticate against the remote machine. You could
then use CFEXECUTE to run that.
Alternatively, you could actually do this through a database query - if your
query runs, then the database is presumably running. Given a sufficiently
privileged database account, you could use sp_cmdshell to run commands on
the database server to see if the Agent service is running. I would hope
that your database account isn't that privileged, though, as that would be a
significant security problem. There may also be a way to check the Agent
service status without so many privileges, too.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231589
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations Support: http://www.houseoffusion.com/tiny.cfm/54
