3 Replies Latest reply on Dec 3, 2012 10:33 AM by ranit B

    How to create an automatic alert for 1hour?

      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.