From "Oracle Built-in Packages" by O'REILLY


This sql*plus script sumbits a job that uses dbmsddl.analyze_object to
analyze a patricular table every day at midnight.

var jobno number
begin
DBMS_JOB_SUBMIT
(job => :jobno
, what => 'DBMS_DDL.ANALYZE_OBJECT(''TABLE'',''LOAD1'',''TENK'',
''EXTIMATE'',null,estimate_percent=>50);'
,next_date => TRUNC(SYSDATE+1)
,INTERVAL => 'TRUNC(SYSDATE+1)'
);
end;
/
print jobno

Vishnu S. Gurunathan wrote:

>Hi,
> How can we submit a job in oracle using dbms_job package??
>How get set / get the value of the job id in the parameter of the dbms_job.submit(job_id,'procedure_name',nextvalue,interval,..)
>Thank you in advance!
>
>
>
>
>Regards,
>VishnuSankar.GP
>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
>Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual
>or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under
>applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or [Email address protected]
>and delete this EMAIL including any attachments
>_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>
>

Oracle LazyDBA home page