<div>
job runs just &nbsp;for a few seconds.
</div>


<div>
<div class="content wysiwyg-content">
Originally it was <br />
<br />
--dbms job run every 1st of the month for monthly proposed annual goal report<br />
<br />
DECLARE<br />
&nbsp; &nbsp; x &nbsp; NUMBER;<br />
BEGIN<br />
dbms_job.submit(job =&gt; X,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; what =&gt; 'mthly_prop_goal_imp_prc;'<wbr /> ,<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; next_date =&gt; trunc(add_months(sysdate, 1), 'mm'),<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; interval =&gt; 'trunc(add_months(sysdate,<wbr /> 1), ''mm'')',<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; no_parse =&gt; true);<br />
commit;<br />
end;<br />
<br />
I need to create a job that will run last day of the month at 11.00pm<br />
Need help
</div>
</div>


Originally it was 

--dbms job run every 1st of the month for monthly proposed annual goal report

DECLARE
    x   NUMBER;
BEGIN
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);
commit;
end;

I need to create a job that will run last day of the month at 11.00pm
Need help

dbms job submit

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.