durai nagarajan (8/30/2013)
Grant already you informed that it is not the best solution, my question is what if agent is down.we definetely need a service out of SQL to monitor these. hopw you agree
Apologies. You didn't mention SQL Agent, so I didn't realize that's what you meant.
It's a question of another service on another server to monitor the monitor. You can use a different SQL Agent to monitor the first one. You can set up a Policy Based Management process on another server to monitor the Agent. You can write a PowerShell script that connects/disconnects in a loop and the first time it can't connect, it sends you an email. You have lots of choices.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning