I want to schedule the job to run on the 1st of every month. I have the code and wanted to be sure if this is correct before I schedule.
runs on september 1st 2014 and there on every 1st of the month
--dbms job run every 1st of the month for monthly proposed annual goal report
dbms_job.submit(job => X,
what => 'mthly_prop_goal_imp_prc;' ,
next_date => trunc(add_months(sysdate, 1), 'mm'),
interval => 'trunc(add_months(sysdate, 1), 'mm')',
no_parse => true);