Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajani
Constraint Violating Yak Guru
367 Posts |
 Posted - 2005-11-27 : 16:12:04
|
| Hi friendswe have sql server 2000 on a server machine.and we've some maintenance jobs that run at 6.30pm everyday. the last week our system administrator has changed administrator password and suddenly Sql agent service stopped saying "logon" failure!! we only came to know today that service is actually stopped and it has not been running any of maintenance jobs!!is there any way that when service stopped for any reason or when job failed to get any notification. BTW In my abv case we dont have any errors in the log as agent service is not running at all.yah , we changed password for this service(under services) and got it working again.Thanks for your help.Cheers |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-27 : 21:05:27
|
| Since we have multiple SQL Servers at our site, we have scheduled jobs that run on servers to check if it can connect to SQL Server on the other servers, and checks to see if the Agent is running. If it fails to connect, it sends us a page via email. This works very well for us, and we find out about problems right away. There are also enterprise solutions, like HP Open View, that are designed for detecting this type of propblem.CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-11-28 : 02:10:03
|
| You might be able to concoct a BATch task using NET START - that will list the Services currently running, which you could do a FIND on looking for SQL Server + SQL Agent. There is a freebie command line emailing tool called BLAT.EXE which can then be set to EMail you the resultsKristen |
|
|
|
|
|
|
agent service stopped and we dont know!!