February 19, 2010 at 12:02 pm
hi..
i want to know.i want to know how email alert send to the person if sql server/agent stops.
can i have the procedure for that...
February 19, 2010 at 12:53 pm
http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell
It looks like this can be adapted to the SQL Server service itself.
February 19, 2010 at 1:01 pm
i want an email alert to operator...
February 19, 2010 at 1:31 pm
Do you mean operator in the SQL Sever sense, that is, the operators listed under SQL Sever Agent in Management Studio?
If the server /agent services are down you won't be able to use the SQL server Agent operators. Unless you are using one server to monitor another.
February 19, 2010 at 1:39 pm
yes how can i monitor 1 server from another in the same domain?
February 19, 2010 at 2:52 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply