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 run time of both the jobs. (i.e when i run the query it should show me how long job has been running)
Could you please help me on this?
Ask your questions, our development team will try to give answers to your questions.