About jobs

[josecarlo]

Hi,

Can anybody tell me how to delete a job and create a new one? I have one that it didn't make its work, so I want to delete it and create a new one. My job had to refresh a materialized view every day. Thanks.

Jose Carlos



JOSE CARLOS ARAMBURU
josecarloaa@hotmail.com

 

[maxpower1]

these are called snp jobs in oracle.

at the command prompt:>

sql> exec dbms_job.isubmit(999, 'storedprocname',startdate, interval, null);

sql> commit;

to stop
sql> dbms_job.remove(999);


job number, 999, must match!

~za~
You can't bring back a dead thread!