Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Write a Dbms_scheduler to run a job frequently

791888Nov 26 2010 — edited Nov 29 2010
Hi,

I need to write dbms_scheduler to run the job on monthly basis which would delete data from database which are of 2 year old from sysdate.

For Eg: I have 50000 records in my table which are of differetn dates stored in database since 3 years.
If I run the job today, records which are created before today's date 2 years back should be deleted.


Can any one help me in step by step process as how can I do it as I am new in writing jobs.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2010
Added on Nov 26 2010
#dba, #pl, #sql
9 comments
414 views