Scheduling of Reports Issue (Not being picked up and run) [message #222488] |
Mon, 05 March 2007 02:53 |
steven.legge
Messages: 1 Registered: February 2007 Location: Newbrigdge Wales
|
Junior Member |
|
|
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
OK.
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.
Note :
select value from v$parameter where name ='job_queue_processes';
2
select value from v$parameter where name ='job_queue_interval';
600
Thanks
Steve
|
|
|