Database Software

Hi All,

I have millions of records to insert into database.I schedule the job at midnight if it is unable to complete by morning 6AM. i want stop the job immediately and i have to reschedule the remaining records next day midnight.i am maintaing the status of inserted records .

i tried like this. i have broken the the job. but still it is running and inserting the data into table.

declare
v_job number;
begin
dbms_job.submit(v_job,'temp1;');
commit;
end;

begin
dbms_job.BROKEN( 41,true,trunc(sysdate+1));
commit;end;


How to achieve this logic.

Please give me any suggestions.

Thanks,
Ram.