This discussion is archived
3 Replies Latest reply: Dec 3, 2012 2:29 AM by karthiksingh_dba RSS

How to create an automatic alert for 1hour?

karthiksingh_dba Explorer
Currently Being Moderated
Dear Legends,

I'm trying to check a table which provides a status of a Process - such as 'S' & 'E'. In this some process get stuck(S) so that i have to do

1. an alert for those processes which hangs for more than 1 hour.
2. Simultaneously i have to update the status column value S to E for every one hour, with where condition of proc_id column.

How do i create an automatic alert and update with comparing the timestamp of the columns?

Kindly request you to help me on this. Thanks in advance.

Regards,
Karthik

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points