Getting this issue [message #413502] |
Thu, 16 July 2009 02:16 |
rajasekhar857
Messages: 500 Registered: December 2008
|
Senior Member |
|
|
BEGIN
DBMS_SCHEDULER.drop_job
(
job_name => 'EMREncounterData_Sync',
force => FALSE
);
dbms_scheduler.create_job(
job_name=>'EMREncounterData_Sync',
job_type=>'PLSQL_BLOCK',
job_action=>'BEGIN
EXECUTE IMMEDIATE(''alter index HPI_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index ROS_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index PHYSICAL_EXAM_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index DIAGNOSIS_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index PLAN_DATA_Index rebuild online parameters(''''sync'''')'');
EXECUTE IMMEDIATE(''alter index ICD9_DATA_Index rebuild online parameters(''''sync'''')'');
commit; END;',
start_date=>TRUNC(SYSDATE+1),
repeat_interval=>'TRUNC(SYSDATE+1)',
end_date=>NULL,
enabled=>TRUE,
comments=>'Full text indexing');
END;
/
COMMIT
/
Error report:
ORA-27475: "EZEMRXMODERNCLI.EMRENCOUNTERDATA_SYNC" must be a job
ORA-06512: at "SYS.DBMS_ISCHED", line 178
ORA-06512: at "SYS.DBMS_SCHEDULER", line 544
ORA-06512: at line 2
27475. 00000 - "\"%s.%s\" must be a %s"
*Cause: An object of the wrong type was specified. For example, a table
could have been passed to the drop_job() procedure.
*Action: Reissue a different command applicable to this object type or
reissue the same command using an object of the valid type.
what is this actually and how to solve this kind of errors
|
|
|
Re: Getting this issue [message #413503 is a reply to message #413502] |
Thu, 16 July 2009 02:38 |
bonker
Messages: 402 Registered: July 2005
|
Senior Member |
|
|
If you have coded this then you must know how to debug as well?
The error is quite obvious "ORA-27475: "EZEMRXMODERNCLI.EMRENCOUNTERDATA_SYNC" must be a job"
I am guessing that EMRENCOUNTERDATA_SYNC job does not exist at the time you try to drop it and therefore its failing with error ORA-27475
[Updated] last sentence was incomplete earlier.
[Updated on: Thu, 16 July 2009 02:46] Report message to a moderator
|
|
|