Tuesday, March 20, 2012

Alert

Hi,
I have a question regarding alerts in SQL Server.
From what I`ve read an alert tracks a certain logged information and if the
info matches the alert definition then the alert fires up.
My question is, for instance, I want to define a Perfmon alert that will
trigger a message in the windows application log when something happens.
Is it possible to configure a SQL Server alert that will catch the string
defined in the Perfmon Alert, from the Windows application log...and if yes,
how can I configure the SQL Server alert.
e.g. I define a perfmon alert that says "Hello" when the disk space on C:
drive falls under 100Mb, is it possible to define a job that triggers when in
the windows application log a certain Information/Warrning/Error contains in
its definition the "Hello" string?
Thx
Razvan Dragomir,
MCSA / MCSA: Messaging, Exchange & Windows System Administrator
I meant to say "alert" not "job"...sorry for the mistake
Razvan Dragomir,
MCSA/MCSA:Messaging Exchange & Windows System Administrator
"Razvan Dragomir" wrote:

> Hi,
> I have a question regarding alerts in SQL Server.
> From what I`ve read an alert tracks a certain logged information and if the
> info matches the alert definition then the alert fires up.
> My question is, for instance, I want to define a Perfmon alert that will
> trigger a message in the windows application log when something happens.
> Is it possible to configure a SQL Server alert that will catch the string
> defined in the Perfmon Alert, from the Windows application log...and if yes,
> how can I configure the SQL Server alert.
> e.g. I define a perfmon alert that says "Hello" when the disk space on C:
> drive falls under 100Mb, is it possible to define a job that triggers when in
> the windows application log a certain Information/Warrning/Error contains in
> its definition the "Hello" string?
>
> Thx
> --
> Razvan Dragomir,
> MCSA / MCSA: Messaging, Exchange & Windows System Administrator
>

No comments:

Post a Comment