Find the Running time in sql***

Home Answers Viewqa SQL Find the Running time in sql***

QuestionAsk Questions?

Pranesh

Find the Running time in sql***
0 Answer(s) 2 years and 6 months ago
Posted 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

Find the Running time in sql***

How to find run time in SQL.

WEBSERVICE USING APACHE AXIS TUTORIAL-2 UNDERSTANDING APACHE AXIS

Sqlite3

SQLLoader

SQLite3

sqlserver2008

store html value in the sqllite 3 php

SQLite

WEBSERVICE USING APACHE AXIS TUTORIAL-2 UNDERSTANDING APACHE AXIS (part-2)

What is SQLLoader?

how to do CRUDE operation in iphone?-RV

What is SQLExceptionTranslator?

WEBSERVICE USING APACHE AXIS TUTORIAL-2 UNDERSTANDING APACHE AXIS

running time watch

Looking for change password in iphone application sdk using sqlite

How to display images in jsp ffrom sqlserver2000 - JSP-Servlet

sqlexception - SQL

JDBC4.0-SQL Exception Handling Enhancements

SQLExceptionTranslator example

sql - SQL

sqlexception - Hibernate

DEVELOPING & DEPLOYING A PACKAGED EJB (WEBLOGIC-7) & ACCESSING IT BY A PACKAGED SERVLET (TOMCAT4.1)

DEVELOPING & DEPLOYING A PACKAGED EJB

Sql

Enhanced SQL Exception Handling

Spring SqlRowSet example

i cant find any compile time error but there is runtime error.

SQLl query count and group by

ms sqlserver

Java search from sqlservr

time

Hibernate criteria sqlRestriction.

NSuserDefault or Sqlite

J2EE Tutorial - Running RMI Example

SQLite Table

identify the order of the average running time of the method

identify the order of growth of the average running time of the method.

sqllllllll - Java Beginners

Ant Script to Create Mysql Table

ALL command - SQL

jsp with sqlserver - JDBC

prepared statement in sqlite

how to create a databaseconnectvity using SQLSERVER2005 in J2ME - JDBC

to know sql qyery execution time

Session Last Accessed Time Example

Reporting tool for sqlserver2000 with java or jsp

Ask Questions?

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.

Tutorial Topics