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

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 23 May 2005 10:49:12 -0400
Message-ID: <9177895d050523074955ac1c91@mail.gmail.com>

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

Received on Mon May 23 2005 - 10:53:57 CDT