This content has been marked as final. Show 2 replies
Problem is the argument value expression is only evaluated at creation time. Years ago I filed an enhancement request to allow for parameter functions to make the use of parameters more dynamic. You could work around this with a wrapper that calls the stored procedure with the sysdate as an argument, instead of the scheduler calling your stored procedure directly.