Re: how to schedule a job on second saturday using cron ?

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: John.Hallas@xxxxxxxxxxxxxxxxx
  • Date: Mon, 23 May 2005 10:49:12 -0400

I'd schedule it every Tue, in the beginning of the script do a check if it 
is second, if so, proceed, if not return/exit from code, here is the pseudo 
code
if trunc(sysdate) = trunc(next_day(trunc(sysdate,'month'),'Tuesday') + 7) 
then
run the job;
else
return;
end;
/

Raj
------------------------------
select standard_disclaimer from company_requirements where category = 
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l

Other related posts: