No obvious reason for the error, I think, but the values for the first run and the interval are just incorrect as they point to past.
Try this:
Has the user the select permission on v$instance?Code:variable jobno number variable instno number BEGIN SELECT instance_number INTO :instno FROM v$instance; DBMS_JOB.SUBMIT(:jobno, 'pms.USP_HRMSMIGRATION;', sysdate+1/1440, 'sysdate+2/1440', TRUE, :instno); COMMIT; END; /
Has he rights to run the procedure?




Reply With Quote