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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-12-18 : 03:48:17
|
| Hi,I have scheduled a job that runs every minute.If the job does not succeed, then I would like my front end application to be notified.I am not sure if this is a reasonable way but I am thinking of somehow populating a table (Only if the scheduled job fails) in sql server and then read that table every minute from the front end application.So, is it possible to populate a table if a job fails?I do not see any options for this in the properties of the job.Thanks |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-18 : 04:25:59
|
Yes,But why do you want to?You can query a system table that has this data already.msdb.dbo.sysjobhistoryDuane.  |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-12-18 : 04:38:45
|
| Very good.It seams this table does not show the time the job was processed. It only shows the date.Thanks |
|
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-12-18 : 04:53:51
|
| It does show time - look at the column run_timeDuane. |
|
|
|
|
|
|
job failure notification