i create a job for updating table and make auto drop after that ,
the problem that when i create this job, one time it's created and one time not , in regular way , and this is the procedure.
job_name => 'DropIp_test',
job_type => 'plsql_block',
job_action => 'begin
dbms_output.put_line(''DELETE EXPIRE : this ip is not expired .'');
update isppro.goldenip_offer_tab set used= 0 where usrname=''testcase'' ; commit; end;',
repeat_interval => 'FREQUENCY=secondly;INTERVAL=1 ',
start_date => systimestamp ,-- '05-AUG-08 04.05.00.859000000 PM -07:00',
end_date => systimestamp + 1/24/60/60 ,--'05-AUG-08 04.05.10.859000000 PM -07:00',
enabled => true,
auto_drop => true);
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!