I have 10 backend jobs in sql which runs at different time intervals. Sample data is shown below
Table name:- Job_Run
Job Name start time job_1 22/10/2010 18:20:00 job_2 22/10/2010 17:30:00
I want to find the running time of both the jobs. (i.e when i run the query it should show me how long job has been running)
Eg:- Lets consider the sysdate as 22/10/2010 20:00. I need the output to be displayed as 1hr 40 min for Job_1 and 2hr 30 min for Job 2
Could you please help me on this?
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.