| Author |
Message |
zinck74
Guest
|
 Posted:
Thu Nov 10, 2005 1:51 am Post subject:
Detect a Long Running SQL Job |
|
|
Hi,
I was wondering if anyone knew of a pre-existing rule I could modify or
how I could create a rule to determine if a SQL job is running over X
number of minutes, hours, etc? I already have the rule implemented if
the job fails, but if it's taking an abnormal amount of time I'd also
like to know. Ideally I'd be able to define the job name too that it's
looking out for, but in this case that I need it for, there is only one
job that would run anywhere close to the amount of time I am expecting.
Thanks,
Bill |
|
| Back to top |
|
 |
Daniel Lai [MVP-Managemen
Guest
|
| Posted:
Thu Nov 10, 2005 9:51 am Post subject:
Re: Detect a Long Running SQL Job |
|
|
Hello,
Thank you for your posting!
Please try to use SQL server management pack
If you have any questions, please feel to let me know. I am glad to be of
assistance.
--
Daniel Lai
Microsoft MVP Program Top Contributor
Windows Server-Management Infrastructure
Microsoft Management Solution Consultant
Culminis GCR Council Member (Hong Kong & Taiwan)
http://msmvps.com/daniel
"zinck74" <bkelly3@gmail.com> wrote in message
news:1131574054.848940.272880@g47g2000cwa.googlegroups.com...
| Quote: | Hi,
I was wondering if anyone knew of a pre-existing rule I could modify or
how I could create a rule to determine if a SQL job is running over X
number of minutes, hours, etc? I already have the rule implemented if
the job fails, but if it's taking an abnormal amount of time I'd also
like to know. Ideally I'd be able to define the job name too that it's
looking out for, but in this case that I need it for, there is only one
job that would run anywhere close to the amount of time I am expecting.
Thanks,
Bill
|
|
|
| Back to top |
|
|
Ryan E
Guest
|
| Posted:
Thu Nov 10, 2005 9:51 pm Post subject:
Re: Detect a Long Running SQL Job |
|
|
The rule I believe you are looking for is "Microsoft SQL Server\SQL Server
2000\SQL Server 2000 Health and Availability Monitoring\SQL Server 2000 Long
Running Agent Jobs". It will alert on any job that runs longer than 60
minutes (configurable). You can also exlude certain jobs from the
monitoring. For more information about this rule, check out the SQL MP
Guide:
http://www.microsoft.com/technet/prodtechnol/mom/mom2005/Library/ee047739-4f0b-4716-bdd2-26fa8e144059.mspx
Thanks
Ryan
"zinck74" <bkelly3@gmail.com> wrote in message
news:1131646411.792616.10070@g44g2000cwa.googlegroups.com...
| Quote: | Ummmm....could you be a tad more detailed? Of course I have the SQL
Server management pack. I'm looking for a specific rule within the
management pack that might help me accomplish this. And failing that,
I would like to know how I might go about creating a custom rule (if
possible) to accomplish this.
Thanks,
Bill
|
|
|
| Back to top |
|
|
zinck74
Guest
|
| Posted:
Thu Nov 10, 2005 9:51 pm Post subject:
Re: Detect a Long Running SQL Job |
|
|
Ummmm....could you be a tad more detailed? Of course I have the SQL
Server management pack. I'm looking for a specific rule within the
management pack that might help me accomplish this. And failing that,
I would like to know how I might go about creating a custom rule (if
possible) to accomplish this.
Thanks,
Bill |
|
| Back to top |
|
|
zinck74
Guest
|
| Posted:
Thu Nov 10, 2005 9:51 pm Post subject:
Re: Detect a Long Running SQL Job |
|
|
Thanks a lot Ryan! Exactly what I was looking for. Don't know how I
missed that. :)
Bill |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in