Scheduling Logic

[Former Member]

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?

Regards,

Shekar

[Former Member]

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'))

begin

$flag=1;

end

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