Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007

    Unanswered: time-based Trigger

    He everybody,

    I have an attribute, its value (AV) is calculated by subtracting the current time from (V). It is required to update the value of the attribute every minute.

    I am thinking to write a stored procedure and calling it from a java thread.

    I am looking for a solution to let the DB2 execute the stored procedure every minute automatically.

    Does DB2 support such action?

    Best Regards,


  2. #2
    Join Date
    Jul 2006
    Pune , India
    you can create a scheduled task that will execute every minute from task centre
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts