Alerts to be emailed to our team

We have a few procedures we want to monitor for issues... and want to know
how to enable alerts to notify our team when there is an issue..
We have error logging enabled within the procedure.. which is writing the
errors to a table, but unless we go out and view that table we dont know if
the procedure failed...
So what can we use within the SQL2005 to send our team an email that the
procedure failed?
we have alerts working with our scheduled Jobs but want to use it to alert
of the errors as they are written to the table or within the procedure..
whatever is easier...
--
ASP, SQL2005, DW8 VBScriptDaniel,
Provided this is not high-velocity stuff, but is fairly rare, you could add
an ON INSERT trigger to your audit table. That trigger could then do
something such as:
1. Use sp_send_dbmail to email your group
2. Use sp_start_job to start a SQL Agent job that could do whatever you
want, including sending the email.
3. Use RAISERROR to raise an alert that is configured to email, page, etc,
whoever you want to have know about this.
And so on.
If the errors were frequent it would probably be better to skip the trigger,
but create a scheduled job that occasionally runs (every hour?) and reports
on recent activity.
RLF
"Daniel" <dan_c@.h.com> wrote in message
news:O0Zij28fIHA.4260@.TK2MSFTNGP05.phx.gbl...
> We have a few procedures we want to monitor for issues... and want to know
> how to enable alerts to notify our team when there is an issue..
> We have error logging enabled within the procedure.. which is writing the
> errors to a table, but unless we go out and view that table we dont know
> if the procedure failed...
> So what can we use within the SQL2005 to send our team an email that the
> procedure failed?
> we have alerts working with our scheduled Jobs but want to use it to alert
> of the errors as they are written to the table or within the procedure..
> whatever is easier...
> --
> ASP, SQL2005, DW8 VBScript
>

Alerts to be emailed to our team

We have a few procedures we want to monitor for issues... and want to know
how to enable alerts to notify our team when there is an issue..
We have error logging enabled within the procedure.. which is writing the
errors to a table, but unless we go out and view that table we dont know if
the procedure failed...
So what can we use within the SQL2005 to send our team an email that the
procedure failed?
we have alerts working with our scheduled Jobs but want to use it to alert
of the errors as they are written to the table or within the procedure..
whatever is easier...
ASP, SQL2005, DW8 VBScript
Daniel,
Provided this is not high-velocity stuff, but is fairly rare, you could add
an ON INSERT trigger to your audit table. That trigger could then do
something such as:
1. Use sp_send_dbmail to email your group
2. Use sp_start_job to start a SQL Agent job that could do whatever you
want, including sending the email.
3. Use RAISERROR to raise an alert that is configured to email, page, etc,
whoever you want to have know about this.
And so on.
If the errors were frequent it would probably be better to skip the trigger,
but create a scheduled job that occasionally runs (every hour?) and reports
on recent activity.
RLF
"Daniel" <dan_c@.h.com> wrote in message
news:O0Zij28fIHA.4260@.TK2MSFTNGP05.phx.gbl...
> We have a few procedures we want to monitor for issues... and want to know
> how to enable alerts to notify our team when there is an issue..
> We have error logging enabled within the procedure.. which is writing the
> errors to a table, but unless we go out and view that table we dont know
> if the procedure failed...
> So what can we use within the SQL2005 to send our team an email that the
> procedure failed?
> we have alerts working with our scheduled Jobs but want to use it to alert
> of the errors as they are written to the table or within the procedure..
> whatever is easier...
> --
> ASP, SQL2005, DW8 VBScript
>

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?use http://www.sqldev.net/xp/xpsmtp.htm
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I haven't looked at the code
for a long while now. If you want to use this and run into problem, I can provide you with source
code (VB.NET) so you can go in and fix stuff.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and
>reporting on the SQL server. The network admin team is not ok with installing any mail client. Is
>there any other way to have email alerts setup without installing any mail client?
>
>

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?use http://www.sqldev.net/xp/xpsmtp.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I ha
ven't looked at the code
for a long while now. If you want to use this and run into problem, I can pr
ovide you with source
code (VB.NET) so you can go in and fix stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl
..
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and
>reporting on the SQL server. The network admin team is not ok with install
ing any mail client. Is
>there any other way to have email alerts setup without installing any mail
client?
>
>

Alerts

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. The network admin team is
not ok with installing any mail client. Is there any other way to have
email alerts setup without installing any mail client?
use http://www.sqldev.net/xp/xpsmtp.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"docsql" <docsql@.noemail.nospam> wrote in message
news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
>up email alerts and reporting on the SQL server. The network admin team is
>not ok with installing any mail client. Is there any other way to have
>email alerts setup without installing any mail client?
>
>
|||You can use http://www.karaszi.com/SQLServer/util_smtp_alerter.asp. But I haven't looked at the code
for a long while now. If you want to use this and run into problem, I can provide you with source
code (VB.NET) so you can go in and fix stuff.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"docsql" <docsql@.noemail.nospam> wrote in message news:OLBxJoIHGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I have a Windows 2003 server running SQL 2000 SP4. I want to start setting up email alerts and
>reporting on the SQL server. The network admin team is not ok with installing any mail client. Is
>there any other way to have email alerts setup without installing any mail client?
>
>