monitoring SQL jobs

Discussion:

monitoring SQL jobs

(too old to reply)

smeeta

2007-11-07 08:30:01 UTC

Hi,
Does anyone know how SQL Jobs are being monitored in SCOM? I have several
agents.These agents are running SQL 2005, and I have the SQL Server Core
Library, SQL Server 2000 (Monitoring), SQL Server 2000 (Discovery), SQL
Server 2005 (Monitoring), and SQL Server 2005 (Discovery)Management Packs
installed. I also looked through the Rules, i saw one rule related to Jobs
for SQL. And that is under sql 2005 agent 'a sql job failed to complete
successfully'.
i have my own MP.how can i include this rule in my MP so that
alerts can come from that server if any of the SQL job fails.
My queries:
- any more requirements or installations to be done?
- where will the alerts be logged?
can someone provide some useful feedback please..
Thanks in advance....
Smeeta

Anders Bengtsson

2007-11-07 10:18:39 UTC

Permalink

Hi smeeta,

You should look in the SQL MP guide, that guide explains the management pack
and how it works. You can copy/paste the rule to your own managemnet pack
and then reconfigure it. You can also export the first SQL MP and look in
the XML file for configuration tips. Alerts will be seen under Active Alerts
in the console.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se

s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000 (Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005 (Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> My queries:
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

smeeta

2007-11-07 10:42:01 UTC

Permalink

Hi Anders,
the SQL MP that i imported is a sealed one. how can we copy the rule
from there? can you please guide for this. and also as it is a sealed MP, can
we open it as an xml?
thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the management pack
and how it works. You can copy/paste the rule to your own managemnet pack
and then reconfigure it. You can also export the first SQL MP and look in
the XML file for configuration tips. Alerts will be seen under Active Alerts
in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000 (Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005 (Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

Anders Bengtsson

2007-11-07 21:13:40 UTC

Permalink

Hi smeeta,

You can export the managemnet pack from the administration part of the console,
and then look in the XML file.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se

s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s> "Anders Bengtsson" wrote:
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to your
own managemnet pack and then reconfigure it. You can also export the
first SQL MP and look in the XML file for configuration tips. Alerts
will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

smeeta

2007-11-08 06:25:00 UTC

Permalink

Hi Anders,

the problem is we can't export a sealed MP. we dont have that option
on the administration pane of the opeartions console for sealed MPs.
is there any other way out?

Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
You can export the managemnet pack from the administration part of the console,
and then look in the XML file.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to your
own managemnet pack and then reconfigure it. You can also export the
first SQL MP and look in the XML file for configuration tips. Alerts
will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

Anders Bengtsson

2007-11-09 12:46:13 UTC

Permalink

Hi smeeta,

You can do that with command shell, for example

get-managementpack -Name "Microsoft.Windows.Server.AD.2003.Monitoring" |
export-managementpack -Path "C:\"

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se

s> Hi Anders,
s>
s> the problem is we can't export a sealed MP. we dont have that
s> option on the administration pane of the opeartions console for
s> sealed MPs. is there any other way out?
s>
s> Thanks,
s> Smeeta
s> "Anders Bengtsson" wrote:
s>

Post by Anders Bengtsson
Hi smeeta,
You can export the managemnet pack from the administration part of
the console, and then look in the XML file.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to
your own managemnet pack and then reconfigure it. You can also
export the first SQL MP and look in the XML file for configuration
tips. Alerts will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeet

smeeta

2007-11-12 08:00:01 UTC

Permalink

Hi Anders,
i dont think it will work. because it's showing an error as "A
parameter can not be found that matches the parameter name (management pack
name)". i think this command works only for the unsealed MPs as i found it
working for unsealed ones.

Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
You can do that with command shell, for example
get-managementpack -Name "Microsoft.Windows.Server.AD.2003.Monitoring" |
export-managementpack -Path "C:\"
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s>
s> the problem is we can't export a sealed MP. we dont have that
s> option on the administration pane of the opeartions console for
s> sealed MPs. is there any other way out?
s>
s> Thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You can export the managemnet pack from the administration part of
the console, and then look in the XML file.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to
your own managemnet pack and then reconfigure it. You can also
export the first SQL MP and look in the XML file for configuration
tips. Alerts will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

smeeta

2007-11-12 11:19:01 UTC

Permalink

hi Anders,
while monitoring the sql jobs can we pass the job name? i mean,
there might many applications running on the same server. so, how can i
filter the job related to my application?

Post by smeeta
Hi Anders,
i dont think it will work. because it's showing an error as "A
parameter can not be found that matches the parameter name (management pack
name)". i think this command works only for the unsealed MPs as i found it
working for unsealed ones.
Thanks,
Smeeta

Post by Anders Bengtsson
Hi smeeta,
You can export the managemnet pack from the administration part of
the console, and then look in the XML file.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to
your own managemnet pack and then reconfigure it. You can also
export the first SQL MP and look in the XML file for configuration
tips. Alerts will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000 (Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

Anders Bengtsson

2007-11-12 15:33:43 UTC

Permalink

Hi smeeta,

This command works for sealed management packs, but make sure to type it
correct and also to use the correct MP name, not the friendly name.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se

s> Hi Anders,
s> i dont think it will work. because it's showing an error as
s> "A
s> parameter can not be found that matches the parameter name
s> (management pack
s> name)". i think this command works only for the unsealed MPs as i
s> found it working for unsealed ones.
s>
s> Thanks,
s> Smeeta
s> "Anders Bengtsson" wrote:
s>

Post by Anders Bengtsson
Hi smeeta,
You can do that with command shell, for example
get-managementpack -Name
"Microsoft.Windows.Server.AD.2003.Monitoring" | export-managementpack
-Path "C:\"
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s>
s> the problem is we can't export a sealed MP. we dont have that
s> option on the administration pane of the opeartions console for
s> sealed MPs. is there any other way out?
s>
s> Thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You can export the managemnet pack from the administration part of
the console, and then look in the XML file.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi Anders,
s> the SQL MP that i imported is a sealed one. how can we copy
s> the rule
s> from there? can you please guide for this. and also as it is a sealed
s> MP, can
s> we open it as an xml?
s> thanks,
s> Smeeta
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to
your own managemnet pack and then reconfigure it. You can also
export the first SQL MP and look in the XML file for
configuration tips. Alerts will be seen under Active Alerts in
the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

smeeta

2007-11-13 09:09:00 UTC

Permalink

Hi anders,
while monitoring the sql jobs can we pass the job name? i mean,
there might many applications running on the same server. so, how can i
filter the job related to my application?

Thanks,
Smeeta

Post by smeeta
Hi Anders,
the SQL MP that i imported is a sealed one. how can we copy the rule
from there? can you please guide for this. and also as it is a sealed MP, can
we open it as an xml?
thanks,
Smeeta

Anders Bengtsson

2007-11-13 12:49:15 UTC

Permalink

Hi smeeta,

If you for example collect based on event ID and source you can add advanced
criteria and filter on words in the alert description too.

-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se

s> Hi anders,
s> while monitoring the sql jobs can we pass the job name? i mean,
s> there might many applications running on the same server. so, how can
s> i
s> filter the job related to my application?
s> Thanks,
s> Smeeta
s> "smeeta" wrote:
s>

Post by Anders Bengtsson
Hi smeeta,
You should look in the SQL MP guide, that guide explains the
management pack and how it works. You can copy/paste the rule to
your own managemnet pack and then reconfigure it. You can also
export the first SQL MP and look in the XML file for configuration
tips. Alerts will be seen under Active Alerts in the console.
-----
Regards
Anders Bengtsson
Microsoft MVP - MOM
http://www.contoso.se
s> Hi,
s> Does anyone know how SQL Jobs are being monitored in SCOM? I have
s> several
s> agents.These agents are running SQL 2005, and I have the SQL Server
s> Core
s> Library, SQL Server 2000 (Monitoring), SQL Server 2000
(Discovery),
s> SQL
s> Server 2005 (Monitoring), and SQL Server 2005
(Discovery)Management
s> Packs
s> installed. I also looked through the Rules, i saw one rule related
s> to Jobs
s> for SQL. And that is under sql 2005 agent 'a sql job failed to
s> complete
s> successfully'.
s> i have my own MP.how can i include this rule in my MP so
s> that
s> alerts can come from that server if any of the SQL job fails.
s> - any more requirements or installations to be done?
s> - where will the alerts be logged?
s> can someone provide some useful feedback please..
s> Thanks in advance....
s> Smeeta

Continue reading on narkive:

Search results for 'monitoring SQL jobs' (Questions and Answers)

replies

Is programming needed for an I.T. job?

started 2014-05-11 11:22:21 UTC

technology

replies

What are the hottest IT jobs with the best salaries? And what do I need to get there?

started 2007-01-11 11:02:01 UTC

programming & design

replies

Help, anyone know a job for someone with social and generally anxiety?