Creating job, ran successfuly, but not seen on dba_scheduler_jobs
555329May 6 2009 — edited Mar 6 2013Hello working on 10g standard Edition on windows, I'm created an inline job but to execute an OS commend, but this doesn't show up why?
conn dev@souceb
Example:
begin
dbms_scheduler.create_job(job_name =>'EXEMPLE',job_type =>'executable',enabled => true,start_date => SYSTIMESTAMP,job_action =>'c:\temp\cp.cmd');
end;
PL/SQL procedure successfully completed.
SQL> select job_name from dba_scheduler_jobs;
JOB_NAME
------------------------------
AUTO_SPACE_ADVISOR_JOB
GATHER_STATS_JOB
FGR$AUTOPURGE_JOB
PURGE_LOG
RLM$SCHDNEGACTION
RLM$EVTCLEANUP
RS_RESTRICT_ACCESS_90DAYS_JOB
the job EXEMPLE doesn't show up, and when Itry to launch the job, I have the following error
EXEC DBMS_SCHEDULER.RUN_JOB('EXEMPLE',TRUE);
ERROR at line 1:
ORA-27475: "DEV.EXEMPLE" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1
Could someone helps me for this?
Thanks