SQL> exec dbms_scheduler.run_job('Spineload');
BEGIN dbms_scheduler.run_job('Spineload'); END;
*
ERROR at line 1:
ORA-27475: "NAMEDSPRINT.SPINELOAD" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1
=============================
SQL> exec dbms_scheduler.run_job('NAMEDSPRINT.SPINELOAD');
BEGIN dbms_scheduler.run_job('NAMEDSPRINT.SPINELOAD'); END;
*
ERROR at line 1:
ORA-27475: "NAMEDSPRINT.SPINELOAD" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 196
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1
======================================
=======================================
Scheduled job is running fine only when we ran manlly its failing to run the job throwing above error.
SQL> SELECT to_char(log_date, 'DD-MON-YY HH24:MI:SS') TIMESTAMP,owner, job_name, status,
additional_info
FROM all_scheduler_job_run_details where status='FAILED' ORDER BY log_date desc; 2 3
TIMESTAMP OWNER
--------------------------- ------------------------------
JOB_NAME
------------------------------------------------------------------------------------------------------------------------
STATUS
------------------------------
ADDITIONAL_INFO
------------------------------------------------------------------------------------------------------------------------
03-JUN-15 06:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_2499",
ORA-27369: job of type EXECUTABLE failed with exit code: No child processes
STANDARD_ERROR="Launching external job failed: Command not found"
02-JUN-15 06:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_2422",
ORA-27369: job of type EXECUTABLE failed with exit code: No child processes
STANDARD_ERROR="Launching external job failed: Command not found"
01-JUN-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_2345",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150601.dat
"
31-MAY-15 08:34:57 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_2234",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150531.dat
"
29-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_2037",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150529.dat
"
28-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1960",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150528.dat
"
27-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1883",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150527.dat
"
26-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1806",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150526.dat
"
25-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1729",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150525.dat
"
24-MAY-15 08:00:02 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1613",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150524.dat
"
23-MAY-15 08:00:02 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1488",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150523.dat
"
22-MAY-15 08:00:00 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1401",
ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address
STANDARD_ERROR="Control File not found - /sprintupload/inbound/pega_control_20150522.dat
"
21-MAY-15 06:00:06 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1325",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
21-MAY-15 06:00:06 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_1324",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
20-MAY-15 06:00:05 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1248",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
20-MAY-15 06:00:05 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_1247",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
19-MAY-15 06:00:05 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1171",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
19-MAY-15 06:00:05 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_1170",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
18-MAY-15 06:00:05 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_1094",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
18-MAY-15 06:00:05 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_1093",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
17-MAY-15 06:00:05 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_980",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
17-MAY-15 06:00:05 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_970",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
16-MAY-15 06:00:07 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_856",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
16-MAY-15 06:00:07 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_851",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
15-MAY-15 06:00:05 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_763",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
15-MAY-15 06:00:05 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_762",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
14-MAY-15 06:00:06 NAMEDSPRINT
IHextracts
FAILED
EXTERNAL_LOG_ID="job_82659_686",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
14-MAY-15 06:00:06 NAMEDSPRINT
Spineload
FAILED
EXTERNAL_LOG_ID="job_82660_685",
ORA-27369: job of type EXECUTABLE failed with exit code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password"
28 rows selected.
Could any one please suggest the solution to fix the above errors.