I assume you have job_queue_processes = n # where n > 0
After submitting the job you did issue a commit in that session?
-Original Message-
Sent: 15 July 2002 16:28
To: Multiple recipients of list ORACLE-L
Hi
I had same situation before. Check owner of the job and security and ad
Have you set job_queue_processes and job_queue_interval parameters? If
job_queue_processes is zero, the job will always run manually but never
automatic.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot c
Hi
I had same situation before. Check owner of the job and security and add
necessary privilege.
Mitchell
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, July 14, 2002 10:33 AM
> Dear gurus !
> I submit a job via the DBMS_JOB package ,
No , it was not ;-)
Sorry , i knew it , but overlooked it ;-)
It's working now !
Thanks a lot to all who replied !
DBAndrey
* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]
-Original Message-
Sent: Sun, July 14, 2002 5:51 PM
To: Andrey Bronfin; LazyDBA.com Discussion
Is job_q
Check if you have a non-zero value for JOB_QUEUE_PROCESSES?
HTH
CP
[EMAIL PROTECTED] wrote:
>Dear gurus !
>I submit a job via the DBMS_JOB package , it looks OK , select from
>user_jobs shows that broken='N' .
>When i execute the job manually , using dbms_job.run , it runs , but it does
>not ru
Andrey,
Are you issuing a "commit" after your dbms_job.submit?
jack
--- Andrey Bronfin <[EMAIL PROTECTED]> wrote:
> Dear gurus !
> I submit a job via the DBMS_JOB package , it looks
> OK , select from
> user_jobs shows that broken='N' .
> When i execute the job manually , using dbms_job.run
>
Dear gurus !
I submit a job via the DBMS_JOB package , it looks OK , select from
user_jobs shows that broken='N' .
When i execute the job manually , using dbms_job.run , it runs , but it does
not run automatically (each 5 minutes , as i have specified when submitting
the job).
Any guess ?
Thanks a