Home › Discussions › Questions & Answers › How to handle dynamic date parameters for scheduled jobs

How to handle dynamic date parameters for scheduled jobs

Avatar photoCustomer Questions & Answers 7 replies

I am setting up a daily scheduled report, and the ‘Date From’ parameter needs to automatically shift to be ‘yesterday’s date’ for every run. How is this dynamic date handling configured?

7 replies

  • Support Enginatics

    For date parameters in scheduled Blitz Reports, you must utilize Oracle’s increment date functionality. This functionality allows the date parameter to adjust dynamically upon each execution of the scheduled concurrent request.

  • Avatar photoCustomer

    So, I configure the dynamic date directly within the Oracle Concurrent Request scheduling screen, not within Blitz Report setup itself?

  • Support Enginatics

    That is correct. You configure the dynamic date logic using the standard Oracle scheduling features available when submitting or copying the concurrent request.

  • Avatar photoCustomer

    If I define a parameter as type ‘Date’ in Blitz Report, does it handle timezone conversion differently from ‘DateTime’ when I input a value?

  • Support Enginatics

    Yes, if timezone conversions are enabled, a ‘Date’ type parameter is used as a bind without any conversion (midnight of the date entered). A ‘DateTime’ type parameter, however, will be converted to server time before execution.

  • Avatar photoCustomer

    What functions can developers use in SQL text that don’t require selecting from dual?

  • Support Enginatics

    Developers can use many standard Oracle functions like `to_char`, `to_date`, `sysdate`, `add_months`, `months_between`, etc., without needing a `select … from dual` clause. This applies mainly when setting default values.

  • You must be logged in to reply to this post.