Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bshamshad
Starting Member
3 Posts |
 Posted - 2007-09-20 : 17:08:07
|
| What is the best way to get notification for a sql server 2005 job that runs longer than certain time. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-20 : 23:08:27
|
| Create a monitoring job for that. |
 |
|
|
bshamshad
Starting Member
3 Posts |
Posted - 2007-09-21 : 10:29:50
|
quote:
Originally posted by rmiao
Create a monitoring job for that.
|
|
|
|
bshamshad
Starting Member
3 Posts |
Posted - 2007-09-21 : 10:35:24
|
| I know that some type of monitoring needs to be set up. Your reply equates to if some one asks about a mechanical issue with their car and you tell them to get it fixed, which they alread know that it needs to be fixed.But my question whether it could be done with some built in functionality or thru scripts?Plus these jobs runs every 5 minutes 24/7 and need to be notified if they run over 10 minutes. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-21 : 23:20:59
|
| There is no such builtin function for that, you have to write your own code and run it in schedule. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-22 : 00:10:02
|
quote:
Originally posted by bshamshad
I know that some type of monitoring needs to be set up. Your reply equates to if some one asks about a mechanical issue with their car and you tell them to get it fixed, which they alread know that it needs to be fixed.But my question whether it could be done with some built in functionality or thru scripts?Plus these jobs runs every 5 minutes 24/7 and need to be notified if they run over 10 minutes.
This functionality isn't built in, you can use MOM with Microsoft SQL Server Management Pack which has a function for this. For a free solution check out the following link:http://www.sqldts.com/271.aspxIt's called Job monitor and it does what you are looking for using only SQL.
Future guru in the making. |
|
|
|
|
|
|
Job notifications