Řešení:
So I how can i solve this issue? You remove the broken status from a job that has been marked as broken with DBMS_JOB.BROKEN with the following syntax: EXEC DBMS_JOB.BROKEN(384,FALSE); Oracle allows you to mark a job you own as broken using the Oracle DBMS_JOB.BROKEN statement. The following is an example of the DBMS_JOB.BROKEN statement: EXEC DBMS_JOB.BROKEN(384,TRUE); The above DBMS_JOB.BROKEN statement will mark Job number 384 as broken. If the job you are marking as broken with the DBMS_JOB.BROKEN statement is running at the time execution the job will continue to run until stopped. If you are unable to stop the job you may wish to kill your Oracle session. If a job has been marked as broken with DBMS_JOB.BROKEN, or has been marked as broken by Oracle, Oracle will not attempt to execute the job until the broken status has been removed or the the job has been forced to execute. To force a job marked as broken, using the DBMS_JOB.BROKEN statement, the following command can be used: EXEC DBMS_JOB.RUN(384);