dbms_job.submit

[rlowe]

All -

I have tried, to no avail to schedule jobs within the database using dbms_job.submit. Code is as follows:

SQL> variable jobNo number;
SQL> begin
2 dbms_job.submit(:jobNo,
3 'sp_summary_table_population;',
4 trunc(sysdate)+0.333,
5 'trunc(sysdate+1)+0.333');
6 commit;
7 end;
8 /

This returns successfully, but the procedure does not run. I have tried every variation I can think of... Is there something fundamentally I am doing wrong? According to the user_jobs table, it is scheduled to run at 7:59:31AM, but it does not run at all... any suggestions?

Thanks,

R

[akkerend]

Is init.ora parameter JOB_QUEUE_PROCESSES set to 1 or higher?

[rlowe]

job_queue_processes was not in the init.ora file, so I added it with a value of 1. I tried again to schedule, but it did not work, so I increased the value by one and tried again to no avail. Any suggestions?

R

[hrishy]

Hello

I think after makin changes to init.ora you forgot to bounce back the database.

regards
hrishy

[pando]

do

alter system set JOB_QUEUE_PROCESSES = 2

[rlowe]

A thousand "thank you"'s. for whatever reason, the alter system... command did what editing the init.ora file did not.

Thanks,

R

[Jani]

Hi
when i run the block the error occurs
ORA-06512: at "SYS.DBMS_JOB"
Can i run any script file ?
Please write the name.
Thanx