I have a connection where I wrote a package that has procedures and functions all in the package. I have an Admin connection to the same server that I use to schedule the job with a different schema.
Schema - Admin
Create Schedule to kick off job(PCOV_CR_EXTRACT) that references the Schema and package.Procedure(See below)
Schema - Service
Has the package with the procedures I want to run.
Script I am running from job
job_name => 'PCOV_CR_EXTRACT',
job_type => 'PLSQL_BLOCK',
job_action => q'[
IF p_Successful > 0
IF p_SuccessfulNames > 0
IF p_successfulCancRein1 > 0
IF p_successfulCancRein2 > 0
start_date => TRUNC(SYSDATE) + 8 / 24,
repeat_interval => 'FREQ=daily;BYHOUR=8;BYMINUTE=0;BYSECOND=0',
enabled => TRUE,
comments => 'Your daily 8am job.');
This doesnt run nor can I see it in any report trying to see what the problem was? Any clues?