dbms_job.submit

[mike2000]

can you use dbms_job package to schedule to run a package???

I think dbms_job only can submit a procedure, but what if I have a package????

thanks

[marist89]

http://tahiti.oracle.com

[slimdave]

you can run a procedure inside a package with dbms_job, if that's what you mean.

[mike2000]

slimdave,

right, I have to procedure inside the package and I need to schedule to run the this package

[slimdave]

declare
job# number;
begin
dbms_job.submit
(
job#,
'begin my_package.my_procedure;end;'
);
end;


... with whatever other dbms_job.submit parameters you need