Dbms_job Packages Errors

[hannah00]

Hi all,

I have package A and in B,C is the procedure inside of the package.

I have never done schedule a package in dbms_jobs before, below is what I have in mind

var x number
begin
dbms_job.submit(:x, 'begin A.B; end;',TRUNC(sysdate)+22/24, 'TRUNC(sysdate)+1+22/24');
commit;
end;
/


it doens't work b/c I think I don't have the second proc

thanks,

[davey23uk]

define 'doesnt work'

and also you dont need the begin and end, just a.b

[hannah00]

where can I put the C procedure??? as you see, I only have A for package and B for the first procedure, where can I put the C ???

[davey23uk]

what about c? what do you want to do with it

[hannah00]

since the package A had B,C procedure. I figured I need to have B,C procedure on dbms_job, right??? I don't know how.

[davey23uk]

what?????? that makes no sense, just run what you want to run