I have created job in oracle 11g for sending emails. some times i observed that this job is continuously executing. when i look in to user_jobs table, i can see field this_sec and this_date having value of current date. I have schedule this job at every 2 hour but some times i observe that this job is executing since last 8 hours and I did not get any result.
One solution i found is that i am killing active session to terminate this job and resubmit the job. but this activity i have to perform manually. Is there any thing available which taken care of this scenario automatically?
Can I do some configuration which will terminate JOB normally and set next interval time in case there is to much delay in execution of JOB?