Thursday, March 22, 2012

alerting for severity levels and not through SQL Alerts

Right now, we do not use the SQL Server Alerts since we
do not have an Outlook profile setup on our SQL Servers.
So is there any other way, i could be alerted for Sev
levels 17-25 thru some sproc that i can call
periodically ?
Also is there a way one can implement this with Site
scope tool ?
> So is there any other way, i could be alerted for Sev
> levels 17-25 thru some sproc that i can call
> periodically ?
One option is mentioned at:
http://www.karaszi.com/sqlserver/info_no_mapi.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Ronald James" <anonymous@.discussions.microsoft.com> wrote in message
news:7bc501c43185$603899b0$a401280a@.phx.gbl...
> Right now, we do not use the SQL Server Alerts since we
> do not have an Outlook profile setup on our SQL Servers.
> So is there any other way, i could be alerted for Sev
> levels 17-25 thru some sproc that i can call
> periodically ?
> Also is there a way one can implement this with Site
> scope tool ?
|||You can still use alerts if you want. You could have the alert start a SQL
Agent job when it is fired that sends a email via CDOSYS of CDONTS. Check
out the KB article:
http://support.microsoft.com/default...b;EN-US;312839
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Ronald James" <anonymous@.discussions.microsoft.com> wrote in message
news:7bc501c43185$603899b0$a401280a@.phx.gbl...
> Right now, we do not use the SQL Server Alerts since we
> do not have an Outlook profile setup on our SQL Servers.
> So is there any other way, i could be alerted for Sev
> levels 17-25 thru some sproc that i can call
> periodically ?
> Also is there a way one can implement this with Site
> scope tool ?
sql

No comments:

Post a Comment