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
>

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 i
n
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 AdministratorI 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 th
e
> 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 stri
ng
> defined in the Perfmon Alert, from the Windows application log...and if ye
s,
> 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
>

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
Thanks
Hello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegr oups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
ThanksHello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegroups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>

Agent started but not started?

I have a SQL 2005 server running on a win2k3 box. For some reason, no
matter what account the SQL Server Agent runs under, error messages
are logged in the security logs. Even if the login account is set to
"local service". BUT if I look at the service under "services", it
says started. It also says started in the SQL 2005 configuration
manager.
Has anyone seen this before?
ThanksHello,
Can you create one test job and try executing. If the job runs then SQL
Agent is working fine...also see the SQLAgent.out file in Log folder of SQL
Server
installation folder for any errors
Thanks
Hari
<costello_joe@.hotmail.com> wrote in message
news:1180399298.618353.292290@.q19g2000prn.googlegroups.com...
> I have a SQL 2005 server running on a win2k3 box. For some reason, no
> matter what account the SQL Server Agent runs under, error messages
> are logged in the security logs. Even if the login account is set to
> "local service". BUT if I look at the service under "services", it
> says started. It also says started in the SQL 2005 configuration
> manager.
> Has anyone seen this before?
> Thanks
>