Missing xp_sqlagent_notify

I'm trying to have an alert fire when it receives an error via the RAISERROR
call. I have it working in SQL 2000, but can't get it to work for SQL 2005.
When I look at the history of the alert, it says that it has not been raised
yet.
When I look at the log from SQLServerAgent, I see that it is missing the
stored procedure xp_sqlagent_notify. Where would I find this missing
procedure? I see that I have an sp_sqlagent_notify -- should I just rename o
r
copy it?
SteveIt sounds like it may not be logging if the history of the
alert indicates it hasn't been raised. Did you create the
message using @.with_log = true or are you raising the error
using with log?
Try testing by doing a raiserror with log. Or you can use
sp_altermessage YourMessageNumber, 'with log', 'true'
to log the message.
-Sue
On Fri, 19 May 2006 11:04:01 -0700, SteveIrwin
<SteveIrwin@.discussions.microsoft.com> wrote:

>I'm trying to have an alert fire when it receives an error via the RAISERRO
R
>call. I have it working in SQL 2000, but can't get it to work for SQL 2005.
>When I look at the history of the alert, it says that it has not been raise
d
>yet.
>When I look at the log from SQLServerAgent, I see that it is missing the
>stored procedure xp_sqlagent_notify. Where would I find this missing
>procedure? I see that I have an sp_sqlagent_notify -- should I just rename
or
>copy it?
>Steve|||That worked, Sue. Thanks!
Steve
"Sue Hoegemeier" wrote:

> It sounds like it may not be logging if the history of the
> alert indicates it hasn't been raised. Did you create the
> message using @.with_log = true or are you raising the error
> using with log?
> Try testing by doing a raiserror with log. Or you can use
> sp_altermessage YourMessageNumber, 'with log', 'true'
> to log the message.
> -Sue
> On Fri, 19 May 2006 11:04:01 -0700, SteveIrwin
> <SteveIrwin@.discussions.microsoft.com> wrote:
>
>

Missing xp_sqlagent_notify

I'm trying to have an alert fire when it receives an error via the RAISERROR
call. I have it working in SQL 2000, but can't get it to work for SQL 2005.
When I look at the history of the alert, it says that it has not been raised
yet.
When I look at the log from SQLServerAgent, I see that it is missing the
stored procedure xp_sqlagent_notify. Where would I find this missing
procedure? I see that I have an sp_sqlagent_notify -- should I just rename or
copy it?
SteveIt sounds like it may not be logging if the history of the
alert indicates it hasn't been raised. Did you create the
message using @.with_log = true or are you raising the error
using with log?
Try testing by doing a raiserror with log. Or you can use
sp_altermessage YourMessageNumber, 'with log', 'true'
to log the message.
-Sue
On Fri, 19 May 2006 11:04:01 -0700, SteveIrwin
<SteveIrwin@.discussions.microsoft.com> wrote:
>I'm trying to have an alert fire when it receives an error via the RAISERROR
>call. I have it working in SQL 2000, but can't get it to work for SQL 2005.
>When I look at the history of the alert, it says that it has not been raised
>yet.
>When I look at the log from SQLServerAgent, I see that it is missing the
>stored procedure xp_sqlagent_notify. Where would I find this missing
>procedure? I see that I have an sp_sqlagent_notify -- should I just rename or
>copy it?
>Steve|||That worked, Sue. Thanks!
Steve
"Sue Hoegemeier" wrote:
> It sounds like it may not be logging if the history of the
> alert indicates it hasn't been raised. Did you create the
> message using @.with_log = true or are you raising the error
> using with log?
> Try testing by doing a raiserror with log. Or you can use
> sp_altermessage YourMessageNumber, 'with log', 'true'
> to log the message.
> -Sue
> On Fri, 19 May 2006 11:04:01 -0700, SteveIrwin
> <SteveIrwin@.discussions.microsoft.com> wrote:
> >I'm trying to have an alert fire when it receives an error via the RAISERROR
> >call. I have it working in SQL 2000, but can't get it to work for SQL 2005.
> >When I look at the history of the alert, it says that it has not been raised
> >yet.
> >
> >When I look at the log from SQLServerAgent, I see that it is missing the
> >stored procedure xp_sqlagent_notify. Where would I find this missing
> >procedure? I see that I have an sp_sqlagent_notify -- should I just rename or
> >copy it?
> >
> >Steve
>

missing sql alert catergory

Hi,
When you go to EM and try to define a new alert
under 'management', 'sql server agent', there should have
two types of alerts in the selection: 'sql server event
alert', and 'sql server performance condition alert'.
One of my server is missing the second type of alert (It's
not in the drop-down box).
Any thought on what happened there and how to get it back?
Thanks a lot.
JJDo you have the SQL Server perfmon counters in perfmon? Any rows in
master..sysperfinfo? Is SQL Server started with the -x switch?
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> Hi,
> When you go to EM and try to define a new alert
> under 'management', 'sql server agent', there should have
> two types of alerts in the selection: 'sql server event
> alert', and 'sql server performance condition alert'.
> One of my server is missing the second type of alert (It's
> not in the drop-down box).
> Any thought on what happened there and how to get it back?
> Thanks a lot.
> JJ|||thanks, Tibor.
You are right on the target! sql server perfmon counters
are missing in perfmon on this server as well. And there
is nothing in master..sysperfinfo.
How can I get them back without risking potentially harm
the system?
SQL Server started with the -x means 'Disables the keeping
of CPU time and cache-hit ratio statistics. Allows maximum
performance.' right? I did not start sql server
explicitly this way. our server is set to be auto-restart
and I think we are just using the default settings for
startup.
Why should I choose '-x'?
thanks.
JJ
>--Original Message--
>Do you have the SQL Server perfmon counters in perfmon?
Any rows in
>master..sysperfinfo? Is SQL Server started with the -x
switch?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at:
>http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
message
>news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
>> Hi,
>> When you go to EM and try to define a new alert
>> under 'management', 'sql server agent', there should
have
>> two types of alerts in the selection: 'sql server event
>> alert', and 'sql server performance condition alert'.
>> One of my server is missing the second type of alert
(It's
>> not in the drop-down box).
>> Any thought on what happened there and how to get it
back?
>> Thanks a lot.
>> JJ
>
>.
>|||JJ,
I was thinking that perhaps the SQL Server was started with the -x switch
and that was the reason the counters was missing. EM, right-click the
server, Startup Parameters.
I suspect, however that the counters aren't properly registered in the
registry. There's an exe files that does this, but I always forget the name
of this file. I didn't find it in the SQL Server directories, so it is
probably in the windows directory somewhere. I suggest that you search the
archives or post a new thread with appropriate subject.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in message
news:058c01c3a97d$22e5d680$a401280a@.phx.gbl...
> thanks, Tibor.
> You are right on the target! sql server perfmon counters
> are missing in perfmon on this server as well. And there
> is nothing in master..sysperfinfo.
> How can I get them back without risking potentially harm
> the system?
> SQL Server started with the -x means 'Disables the keeping
> of CPU time and cache-hit ratio statistics. Allows maximum
> performance.' right? I did not start sql server
> explicitly this way. our server is set to be auto-restart
> and I think we are just using the default settings for
> startup.
> Why should I choose '-x'?
> thanks.
> JJ
> >--Original Message--
> >Do you have the SQL Server perfmon counters in perfmon?
> Any rows in
> >master..sysperfinfo? Is SQL Server started with the -x
> switch?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at:
> >http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"JJ Wang" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:020f01c3a954$1aa89a30$a401280a@.phx.gbl...
> >> Hi,
> >>
> >> When you go to EM and try to define a new alert
> >> under 'management', 'sql server agent', there should
> have
> >> two types of alerts in the selection: 'sql server event
> >> alert', and 'sql server performance condition alert'.
> >>
> >> One of my server is missing the second type of alert
> (It's
> >> not in the drop-down box).
> >>
> >> Any thought on what happened there and how to get it
> back?
> >>
> >> Thanks a lot.
> >>
> >> JJ
> >
> >
> >.
> >