ORA-27476: "MAXIMO.MAXIMOTSSYNC" does not exist
This problem Mainly i faced during Upgrading Maximo 7.1.1.10 to Maximo 7.5.0.
Step 1 : Change to use DBMS_SCHEDULER
CREATE OR REPLACE PROCEDURE maximo_ts_job_call AS
BEGIN
dbms_scheduler.create_job(
job_name => 'MAXIMOTSSYNC',
job_type => 'STORED_PROCEDURE',
job_action => 'maximo_ts_job',
start_date => SYSDATE,
repeat_interval => 'SYSDATE + 5/1440',
enabled => TRUE);
END;
/
exec maximo_ts_job_call();
select job, substr(what,1,80) from user_jobs;
Re-run Integrity checker
This problem Mainly i faced during Upgrading Maximo 7.1.1.10 to Maximo 7.5.0.
Step 1 : Change to use DBMS_SCHEDULER
CREATE OR REPLACE PROCEDURE maximo_ts_job_call AS
BEGIN
dbms_scheduler.create_job(
job_name => 'MAXIMOTSSYNC',
job_type => 'STORED_PROCEDURE',
job_action => 'maximo_ts_job',
start_date => SYSDATE,
repeat_interval => 'SYSDATE + 5/1440',
enabled => TRUE);
END;
/
exec maximo_ts_job_call();
select job, substr(what,1,80) from user_jobs;
Re-run Integrity checker
No comments:
Post a Comment