Will you ever stop abusing this forum with elementary questions, showing you are unwilling to do what you are paid for (and we aren't): YOUR JOB!
Senior Oracle DBA
But that is already in masteral level
Are you capable of writing a SQL query to do this? Try it, then post your effort if you are stuck.
Have you heard of DBMS_SCHEDULER? Read up on it, and let us know if you think it can be used to do what you want.