1 2 Previous Next 18 Replies Latest reply on Mar 7, 2013 1:56 AM by sb92075

Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 7:20 PM

Hello 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

1. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

OrionNet May 6, 2009 7:30 PM (in response to 555329)
Hello,

You need to changed start_date to some future date e..g sysdate + 1. As you are scheduling with current time stamp and it fails and drops (AUTO_DROP=TRUE).

exec dbms_scheduler.create_job(job_name =>'EXEMPLE',job_type =>'executable',enabled => true, auto_drop=> FALSE, start_date => SYSDATE+1,job_action =>'c:\temp\cp.cmd');
Regards

Edited by: OrionNet on May 6, 2009 3:28 PM
Like Show 0 Likes(0)

Actions
2. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

677340 May 6, 2009 7:29 PM (in response to 555329)

I think because as you said, it is an inline creation and no schedule. You should still be able to see your results in the run details if you want to monitor for completion.
Like Show 0 Likes(0)

Actions
3. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 7:40 PM (in response to 677340)

I tried this ans it was ok.
exec dbms_scheduler.create_job(job_name =>'EXEMPLE',job_type =>'executable',enabled => true, auto_drop=> FALSE, start_date => SYSDATE+1,job_action =>'c:\temp\cp.cmd');

But when I ran the job I got the following error:

SQL>
SQL> EXEC DBMS_SCHEDULER.RUN_JOB('EXEMPLE',TRUE);
BEGIN DBMS_SCHEDULER.RUN_JOB('EXEMPLE',TRUE); END;

*
ERROR at line 1:
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with
status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

What may be the reason?

Thanks again
Like Show 0 Likes(0)

Actions
4. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

677340 May 6, 2009 7:43 PM (in response to 555329)

does this exist: 'c:\temp\cp.cmd'?
Like Show 0 Likes(0)

Actions
5. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

OrionNet May 6, 2009 7:46 PM (in response to 555329)

Hello,

This is an external job and you have to use *"cmd" and pass your script as an argument.*

Regards
Like Show 0 Likes(0)

Actions
6. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 7:48 PM (in response to OrionNet)

yes the c:\temp\cp.cmd really exist, and I don't know why it's not seen?
Like Show 0 Likes(0)

Actions
7. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

677340 May 6, 2009 7:55 PM (in response to 555329)

Ok..OrionNet got it...here is an example...tailor it to your stuff and give it a try.

begin
dbms_scheduler.create_job('myjob',
job_action=>'C:\WINDOWS\SYSTEM32\CMD.EXE',
number_of_arguments=>1,
job_type=>'executable', enabled=>False);
dbms_scheduler.set_job_argument_value('myjob',1,'c:\temp\test.bat');
dbms_scheduler.enable('myjob');
end;
/
Like Show 0 Likes(0)

Actions
8. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 8:09 PM (in response to 677340)

This is what I'm getting as error, any idea?

SQL> begin
2 dbms_scheduler.create_job('myjob',
3 job_action=>'C:\WINDOWS\SYSTEM32\CMD.EXE',
4 number_of_arguments=>1,
5 job_type=>'executable', enabled=>False);
6 dbms_scheduler.set_job_argument_value('myjob',1,'c:\temp\cp.bat');
7 dbms_scheduler.enable('myjob');
8 end;
9 /

PL/SQL procedure successfully completed.

SQL> EXEC DBMS_SCHEDULER.RUN_JOB ('myjob');
BEGIN DBMS_SCHEDULER.RUN_JOB ('myjob'); END;

*
ERROR at line 1:
ORA-27475: "DEV.MYJOB" 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

Thanks
Like Show 0 Likes(0)

Actions

9. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

OrionNet May 6, 2009 8:15 PM (in response to 555329)

Hello,

Once again your job create/failed and dropped

Try this

BEGIN
   DBMS_SCHEDULER.create_job ('myjob',
                              job_action => 'C:\WINDOWS\SYSTEM32\CMD.EXE',
                              number_of_arguments => 1,
                              start_date=> sysdate+1,
                              auto_drop=>FALSE,
                              job_type => 'executable',
                              enabled => FALSE
   );
   DBMS_SCHEDULER.set_job_argument_value ('myjob', 1, 'c:\temp\cp.bat');
   DBMS_SCHEDULER.enable ('myjob');
END;

Edited by: OrionNet on May 6, 2009 4:15 PM

10. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 8:31 PM (in response to OrionNet)

Thank you very much, but when i run the job it ran fine:

SQL> EXEC DBMS_SCHEDULER.RUN_JOB ('MYJOB',TRUE);

PL/SQL procedure successfully completed.

but there is no result on what I'm seeking, the following is the contents of the cp.bat
copy c:\temp\sqlnet.log c:\temp\temp\

there is a reason for that?

Thanks enough
Like Show 0 Likes(0)

Actions
11. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

OrionNet May 6, 2009 8:37 PM (in response to 555329)

Hello,

Check the failure_count for this job under user_scheduler_jobs and run your script manually to see if it really work and suppose to do what it's in there.

Hope this helps.

Regards
Like Show 0 Likes(0)

Actions
12. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 9:11 PM (in response to OrionNet)

I don't what really is going on with my system but the creation of the job works fine, but I'm getting this error:

SQL> EXEC DBMS_SCHEDULER.RUN_JOB ('MYJOB');
BEGIN DBMS_SCHEDULER.RUN_JOB ('MYJOB'); END;

*
ERROR at line 1:
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with
status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

other reason gotten from the dba_scheduler_job_run_details:
select status,run_duration,session_id,additional_info from dba_SCHEDULER_JOB_RUN_DETAILS where job_name='MYJOB';

ORA-27370: job slave failed to launch a job of type
EXECUTABLE
ORA-27300: OS system dependent operation:accessing
execution agent failed with status: 2
ORA-27301: OS failure message:
The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cann
ot find the file specified.

Any tips?

Thanks
Like Show 0 Likes(0)

Actions
13. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

555329 May 6, 2009 9:13 PM (in response to OrionNet)

I'm getting the following errors:

SQL> EXEC DBMS_SCHEDULER.RUN_JOB ('MYJOB');
BEGIN DBMS_SCHEDULER.RUN_JOB ('MYJOB'); END;

*
ERROR at line 1:
ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with
status: 2
ORA-27301: OS failure message: The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cannot find the file specified.
ORA-06512: at "SYS.DBMS_ISCHED", line 150
ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
ORA-06512: at line 1

select status,run_duration,session_id,additional_info from dba_SCHEDULER_JOB_RUN_DETAILS where job_name='MYJOB';

ORA-27370: job slave failed to launch a job of type
EXECUTABLE
ORA-27300: OS system dependent operation:accessing
execution agent failed with status: 2
ORA-27301: OS failure message:
The system cannot find the file specified.
ORA-27302: failure occurred at: sjsec 6a
ORA-27303: additional information: The system cann
ot find the file specified.

Any tips?

Thanks
Like Show 0 Likes(0)

Actions
14. Re: Creating job, ran successfuly, but not seen on dba_scheduler_jobs

677340 May 7, 2009 12:51 PM (in response to 555329)

have you given CREATE EXTERNAL JOB to the user trying to run the job? Maybe try that and see if it makes any difference.
Like Show 0 Likes(0)

Actions

1 2 Previous Next

Go to original post