| starting a job from job library from batch file [message #67805] |
Thu, 04 April 2002 13:57  |
Satya
Messages: 36
Registered: January 2001
|
Member |
|
|
I would like to start a job in the job libary from a batch file or windows scheduler. Does any one know of such capability?
When I try to run a job using dbms_job.submit the job name in the job library is not valid. Any ideas?
|
|
|
|
| Re: starting a job from job library from batch file [message #67806 is a reply to message #67805] |
Fri, 05 April 2002 05:50  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Look at the "at" command from a command prompt (at /?).
Make sure job_queue_interval and job_queue_processes is set in your initSID.ora file.
Check for invalid objects and compile them.
select object_name,object_type from dba_objects where owner='SYS' and status='INVALID';
Make sure you have the required environment variables set.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
