var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: update dbms job
I am trying to change broken job with following code:
DBMS_JOB.BROKEN(JOB => 21, BROKEN => FALSE, NEXT_DATE => TO_DATE('08-10-03 23:00', 'YY-MM-DD HH24:MI'));
but getting this error:
ORA-23421: job number 21 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 245
ORA-06512: at line 2
but on the select from dba_jobs shows job 21 and 22!!
solved it.. was loged in as diffrenet user!! sorry for troubles that i might have cause!!