Re: Export Job

Hi
You must look at a table user_jobs for description of job. Attribute "broken". You can try run job manual
in SQL+. If you will haven`t error code from output, you look at attribute "next_date,next_sec". They value must be changed by attribute`s value "interval".
Other thing is database initial parameters for periodic running : job_queue_processes = 2
job_queue_interval = 60 /this is default value without specification/ Parameter "job_queue_processes " is as default "0";

Tony
ps:
Is a better way when you make job with SQL+ as in the enterprise manager.

Jason Rigsbee <jrigsbee_at_rigsbee.net> wrote in message news:eK7NxfL$$GA.420_at_cpmsnbbsa08...
> Whenever I submit an export job from within Enterprise Manager the job
 sits
> in the active queue (forever) with a status of Submitted. The job never
 is
> run. The attributes for the job is run immediately.
>
> Any ideas on why and how to remedy?
>
> jlr
>
>
Received on Thu Aug 03 2000 - 00:00:00 CEST