Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query for parsing cron expression

Pranay DeepNov 22 2017 — edited Nov 22 2017

Hi all,

I have a requirement, where I need to get the next job run date and time according to cron expression.

for example : for cron expression " 0 0 4 1/1 * ? *  " , job should run everyday at 4 am and my output should be 4:00:00 am ,23 NOV 2016

kindly suggest me query to decrypt this cron expression.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 20 2017
Added on Nov 22 2017
#sql
2 comments
2,796 views