Showing results for 
Search instead for 
Did you mean: 

Scheduling Logic

Former Member
0 Kudos

Hello All,

I have confusion on scheduling job. suppose if i scheduled a job to run every month 31st last day(lest say October), how the job would run on 30th of November as i scheduled job on 31st of every month.

I need the logic how the scheduler process this?



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Reddy,

write the below logic in script and place it in starting of the job

if(date_part((sysdate( )),'DD' )=date_part( last_date( sysdate( )),'DD'))




place your job flow in conditional flow as below

here condition is $flag=1

NOTE: you have to schedule the job every month 28,29,30 and 31 as below