How to create a DBMS Job?
How do I create a dbms job, actually I want a job that should run at a specified time and do a specific job for me such as picking up data from a remote database and then dumping it into my database.
We are using windows as operating system and oracle 8i.
Can you give me an specific example as in I'm new to this...that would be of great help to me.
Per your request.
Example:
Quote:
This submits a new job to the job queue. The job calls the procedure DBMS_DDL.ANALYZE_OBJECT to generate optimizer statistics for the table DQUON.ACCOUNTS. The statistics are based on a sample of half the rows of the ACCOUNTS table. The job is run every 24 hours:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'dbms_ddl.analyze_object(''TABLE'',
''DQUON'', ''ACCOUNTS'',
''ESTIMATE'', NULL, 50);'
SYSDATE, 'SYSDATE + 1');
commit;
END;
/
Hope that helps,
2 comments:
Nice blog, thanks For sharing this informative article.
Oracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Oracle Fusion HCM Online Training
Oracle Fusion HCM Online Training
Post a Comment