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';
--
//www.freelists.org/webpage/oracle-l
Other related posts:
