| Scheduling of Reports Issue (Not being picked up and run) [message #222488]
||Mon, 05 March 2007 02:53
Registered: February 2007
Location: Newbrigdge Wales
Can anyone suggest what I might check with respect to the following.|
1) I have scheduled reports, whereby my own repository is used
for the resulting report storage, and the process completes
2) I then set about creating a "Central Repository"; and set my
user so as to use this area for storing reports data.
I managed to schedule the report Ok, but it has sat there for
the last 3 days, still marked as;
status = scheduled
Date = 01-MAR-07
Time = 01:17 pm
run time = n/a
Any ideas as to why the background processes are not picking
up this work?
As I mentioned, they, the background processes, pick up requests
for work if I use my own repository, so they are working.
select value from v$parameter where name ='job_queue_processes';
select value from v$parameter where name ='job_queue_interval';