Hi Team,
I have previously created DBMS_JOBS in our database and our database is oracle hexadata.
Now, I have to find which DBMS_JOB taking more time to finish as it is affecting other scheduled job performance.
I got the start time of each DBMS_JOB but I am unable to find END time of the same DBMS_JOBS.
I also got Total_Time column in DBA_JOBS table but I am bit confused, whether TOTAL_TIME in seconds or in milliseconds and what exactly it shows?
is it total time which is taken by the job or something other?
Please help me to get end date/time of DBMS_JOB.