> 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
