Find the Running time in sql***

Ads
 

Find the Running time in sql***

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?

View Answers

Ads









Related Tutorials/Questions & Answers:
Find the Running time in sql***
How to find run time in SQL.
Advertisements
Sqlite3
SQLLoader
SQLite3
sqlserver2008
Upgraded MySQL from 5.1 to 5.5, running into PDOException: SQLSTATE[42000]: Syntax error or
SQLite
running time watch
What is SQLLoader?
What is SQLExceptionTranslator?
total time calculator (starttime+endtime) in servlet USING DATABASE IN SQL2000 PLZ ANY ONE HELPME
Looking for change password in iphone application sdk using sqlite
sqlexception - SQL
sqlexception - Hibernate
SQLExceptionTranslator example
Version of com.hynnet>sqljdbc4-chs dependency
identify the order of the average running time of the method
identify the order of growth of the average running time of the method.
identify the order of growth of the average running time of the method.
Spring SqlRowSet example
ms sqlserver
Version of com.mysimpatico>sqlwrapper dependency
Version of com.mysimpatico>sqlwrapper dependency
SQLl query count and group by
Java search from sqlservr
NSuserDefault or Sqlite
store html value in the sqllite 3 php
Version of ca.krasnay>sqlbuilder dependency
SQLite Table
WEBSERVICE USING APACHE AXIS TUTORIAL-2 UNDERSTANDING APACHE AXIS

Ads