I have set the Probe limit of the job to "All". Deactivated and Reactivated the job. One more thing I have noticed that there is a exclamation (!) mark in red colour in front of this "Oracle Database by Connection by SQL" job.
Please can you let me know what does this mark signify.