It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.
I think the code is correct, the job is created...
DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'BEGIN HISR_RETEN.p_hisr_retention_all; END;' ,next_date => to_date('05/09/2013 13:20:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'TRUNC(HISR_UTILITY.f_hisr_sysdate_plus_offset+1/24,''HH'')+(20/(60*24))' ,no_parse => FALSE ); SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x)); COMMIT; END; /
this new job, not appears!
select job, what from user_jobs;