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,

Essam

you can create a scheduled task that will execute every minute from task centre
db2tc