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

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: