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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-23 : 09:45:58
|
Joshua writes "My company has a somewhat open control problem which I have been trying to lock down. In the mean time, several people at night have admin access to my sqlservers. The problem was that at some point during the night, the mssqlservice was stopped and restarted. Unfortunately the sqlagent service was not and havoc ensued. I have two questions:
Can the agentservice be set to start automatically if the mssqlserver service is stopped/restarted? The properties seem to focus on unexpected and os issues rather than user actions.
Second Question:
Keeping in mind that I do not know any programming languages, is there a t-sql way to monitor the sqlagent service to see if it is running?
Perhaps running the job on another sqlserver... inserting a value into a table and sending a page alert if the table is empty.
Any feedback would be appreciated! Thanks, Josh" |
|
|
|
|
|
Monitoring SQLServer Agent?