手动执行作业 出现ora-03001 未实施的功能
如：begin dbms_scheduler.run_job(job_name => 'job_test'); end;
This procedure runs a job immediately.
DBMS_SCHEDULER.RUN_JOB ( job_name IN VARCHAR2, use_current_session IN BOOLEAN DEFAULT TRUE);
The name of the job being run
This specifies whether the job run should occur in the same session as the one that the procedure was invoked from.
The job does not have to be enabled. If the job is disabled, the following validity checks are performed before running it:
The job points to a valid job class.The job owner has
EXECUTEprivileges on the job class.If a program or chain is referenced, the program/chain exists.If a program or chain is referenced, the job owner has privileges to execute the program/chain.All argument values have been set (or have defaults).The job owner has the
CREATE EXTERNAL JOBprivilege if this is an external job.
The job can be run in two different modes. One is in the current user session. In this case, the call to
block until it has completed the job. Any errors that occur during the execution of the job will be returned as errors to the
The other option is to run the job immediately like a regular job. In this case,
immediately and the job will be picked up by the coordinator and passed on to a job slave for execution. The Scheduler views and logs must be queried for the outcome of the job.
Multiple user sessions can use
RUN_JOB in their sessions
use_current_session is set to
RUN_JOB with jobs that point to chains,
RUN_JOB requires that you be the owner of the job or have
on that job. You can also run a job if you have the
如：begin dbms_scheduler.run_job(job_name => 'job_test',use_current_session => false); end; 这样的调用都会记录以下信息：