|
Home > Archive > microsoft.public.sqlserver.server > June 2002 > Re: Raiserror fails to fire alert
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: Raiserror fails to fire alert
|
|
| Christopher J. Riley 2002-06-22, 8:33 pm |
| "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:<udl15rbDCHA.492@tkmsftngp02>...
> When you created the error in sysmessages, did you have it do it WITH LOG?
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Christopher J. Riley wrote in message
> <1bf13216.0206051621.5dfe1403@posting.google.com>...
> I'm trying to use raiserror to cause an alert to fire that will net
> send two operators. I have successfully generated my user-defined
> error (visible in current SQL Server Log) and I can run a test net
> send to both operators. However, the error doesn't fire an alert that
> I have defined to catch the error. Also, I have noticed that the
> error doesn't appear in the nt event log. I have also checked to
> ensure that my eventlog service is running. Any suggestions?
Yes, I did create the message WITH LOG.
| |
| Tom Moreau 2002-06-22, 8:34 pm |
| What severity level are you using?
--
Tom
----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Christopher J. Riley wrote in message
<1bf13216.0206141344.5e58e3b3@posting.google.com>...
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:<udl15rbDCHA.492@tkmsftngp02>...
> When you created the error in sysmessages, did you have it do it WITH LOG?
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Christopher J. Riley wrote in message
> <1bf13216.0206051621.5dfe1403@posting.google.com>...
> I'm trying to use raiserror to cause an alert to fire that will net
> send two operators. I have successfully generated my user-defined
> error (visible in current SQL Server Log) and I can run a test net
> send to both operators. However, the error doesn't fire an alert that
> I have defined to catch the error. Also, I have noticed that the
> error doesn't appear in the nt event log. I have also checked to
> ensure that my eventlog service is running. Any suggestions?
Yes, I did create the message WITH LOG.
| |
| Christopher J. Riley 2002-06-22, 8:35 pm |
| I used a severity level of 9 when I defined my user-defined error
message. I also used the severity level of 9 with raiserror.
Chris
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:<ugaM90HFCHA.2632@tkmsftngp07>...
> What severity level are you using?
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Christopher J. Riley wrote in message
> <1bf13216.0206141344.5e58e3b3@posting.google.com>...
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:<udl15rbDCHA.492@tkmsftngp02>...
> > When you created the error in sysmessages, did you have it do it WITH LOG?
> >
> > --
> > Tom
> >
> > ----------------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > SQL Server MVP
> > Columnist, SQL Server Professional
> >
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > www.apress.com
> > ---
> > Christopher J. Riley wrote in message
> > <1bf13216.0206051621.5dfe1403@posting.google.com>...
> > I'm trying to use raiserror to cause an alert to fire that will net
> > send two operators. I have successfully generated my user-defined
> > error (visible in current SQL Server Log) and I can run a test net
> > send to both operators. However, the error doesn't fire an alert that
> > I have defined to catch the error. Also, I have noticed that the
> > error doesn't appear in the nt event log. I have also checked to
> > ensure that my eventlog service is running. Any suggestions?
>
> Yes, I did create the message WITH LOG.
| |
| Tom Moreau 2002-06-22, 8:35 pm |
| I was able to execute sp_addmessage 50001, 9, 'Doh!', @with_log = 'true' and
then run raiserror (50001, 9). It made an entry into the log. You may want
to try dropping and recreating, reapply service packs, etc.
--
Tom
----------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
www.apress.com
---
Christopher J. Riley wrote in message
<1bf13216.0206181434.1455778c@posting.google.com>...
I used a severity level of 9 when I defined my user-defined error
message. I also used the severity level of 9 with raiserror.
Chris
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:<ugaM90HFCHA.2632@tkmsftngp07>...
> What severity level are you using?
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Christopher J. Riley wrote in message
> <1bf13216.0206141344.5e58e3b3@posting.google.com>...
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:<udl15rbDCHA.492@tkmsftngp02>...
> > When you created the error in sysmessages, did you have it do it WITH
LOG?
> >
> > --
> > Tom
> >
> > ----------------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > SQL Server MVP
> > Columnist, SQL Server Professional
> >
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > www.apress.com
> > ---
> > Christopher J. Riley wrote in message
> > <1bf13216.0206051621.5dfe1403@posting.google.com>...
> > I'm trying to use raiserror to cause an alert to fire that will net
> > send two operators. I have successfully generated my user-defined
> > error (visible in current SQL Server Log) and I can run a test net
> > send to both operators. However, the error doesn't fire an alert that
> > I have defined to catch the error. Also, I have noticed that the
> > error doesn't appear in the nt event log. I have also checked to
> > ensure that my eventlog service is running. Any suggestions?
>
> Yes, I did create the message WITH LOG.
| |
| Sue Hoegemeier 2002-06-22, 8:35 pm |
| I'd agree with Tom's post about the service packs. I don't
think you posted your SQL Server version but on SQL 7, there
are issues with alerts firing on SP 3 and on SQL 2K, there
are issues with alerts firing on SP 1. Moving up to the
latest service pack may very well eliminate the problem.
-Sue
On 18 Jun 2002 15:34:01 -0700, criley@mhsinc.org
(Christopher J. Riley) wrote:
>I used a severity level of 9 when I defined my user-defined error
>message. I also used the severity level of 9 with raiserror.
>
>Chris
>
>
>"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:<ugaM90HFCHA.2632@tkmsftngp07>...
>> What severity level are you using?
>>
>> --
>> Tom
>>
>> ----------------------------------------------------------
>> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
>> SQL Server MVP
>> Columnist, SQL Server Professional
>>
>> Toronto, ON Canada
>> www.pinnaclepublishing.com/sql
>> www.apress.com
>> ---
>> Christopher J. Riley wrote in message
>> <1bf13216.0206141344.5e58e3b3@posting.google.com>...
>> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
>> news:<udl15rbDCHA.492@tkmsftngp02>...
>> > When you created the error in sysmessages, did you have it do it WITH LOG?
>> >
>> > --
>> > Tom
>> >
>> > ----------------------------------------------------------
>> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
>> > SQL Server MVP
>> > Columnist, SQL Server Professional
>> >
>> > Toronto, ON Canada
>> > www.pinnaclepublishing.com/sql
>> > www.apress.com
>> > ---
>> > Christopher J. Riley wrote in message
>> > <1bf13216.0206051621.5dfe1403@posting.google.com>...
>> > I'm trying to use raiserror to cause an alert to fire that will net
>> > send two operators. I have successfully generated my user-defined
>> > error (visible in current SQL Server Log) and I can run a test net
>> > send to both operators. However, the error doesn't fire an alert that
>> > I have defined to catch the error. Also, I have noticed that the
>> > error doesn't appear in the nt event log. I have also checked to
>> > ensure that my eventlog service is running. Any suggestions?
>>
>> Yes, I did create the message WITH LOG.
| |
| Christopher J. Riley 2002-06-25, 7:25 pm |
| I tried your sample without success. I also tried out your sample on
a test machine and it worked there! Thus, the only differences
between the servers that could account for the problem is that my
production server runs NT 4.0 Server SP 6 with SQL Server 2000 SP 2
MSDE edition whereas the test machine runs Windows 2000 Professional
SP 2 with SQL Server 2000 SP 2 Developer edition. Do you have any
idea how this combination could be the culprit?
Chris
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:<OiSxnEyFCHA.2280@tkmsftngp12>...
> I was able to execute sp_addmessage 50001, 9, 'Doh!', @with_log = 'true' and
> then run raiserror (50001, 9). It made an entry into the log. You may want
> to try dropping and recreating, reapply service packs, etc.
>
> --
> Tom
>
> ----------------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> SQL Server MVP
> Columnist, SQL Server Professional
>
> Toronto, ON Canada
> www.pinnaclepublishing.com/sql
> www.apress.com
> ---
> Christopher J. Riley wrote in message
> <1bf13216.0206181434.1455778c@posting.google.com>...
> I used a severity level of 9 when I defined my user-defined error
> message. I also used the severity level of 9 with raiserror.
>
> Chris
>
>
> "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> news:<ugaM90HFCHA.2632@tkmsftngp07>...
> > What severity level are you using?
> >
> > --
> > Tom
> >
> > ----------------------------------------------------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > SQL Server MVP
> > Columnist, SQL Server Professional
> >
> > Toronto, ON Canada
> > www.pinnaclepublishing.com/sql
> > www.apress.com
> > ---
> > Christopher J. Riley wrote in message
> > <1bf13216.0206141344.5e58e3b3@posting.google.com>...
> > "Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
> > news:<udl15rbDCHA.492@tkmsftngp02>...
> > > When you created the error in sysmessages, did you have it do it WITH
> LOG?
> > >
> > > --
> > > Tom
> > >
> > > ----------------------------------------------------------
> > > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCT
> > > SQL Server MVP
> > > Columnist, SQL Server Professional
> > >
> > > Toronto, ON Canada
> > > www.pinnaclepublishing.com/sql
> > > www.apress.com
> > > ---
> > > Christopher J. Riley wrote in message
> > > <1bf13216.0206051621.5dfe1403@posting.google.com>...
> > > I'm trying to use raiserror to cause an alert to fire that will net
> > > send two operators. I have successfully generated my user-defined
> > > error (visible in current SQL Server Log) and I can run a test net
> > > send to both operators. However, the error doesn't fire an alert that
> > > I have defined to catch the error. Also, I have noticed that the
> > > error doesn't appear in the nt event log. I have also checked to
> > > ensure that my eventlog service is running. Any suggestions?
> >
> > Yes, I did create the message WITH LOG.
|
|
|
|
|