Run sql query till mentioned time frame

Question

4.20/5 (2 votes)

See more:

Hi,

I would like to know is there anyway to tell SQL for running query till mentioned time frame (let's say for 5 min)?

If query not executed within given time frame, is there anyway to get error message or error code or something thru which i will come to know that query did not run?

Thanks in advance for help.

Anshul.

Posted 20-Nov-14 9:08am

AJain07

Add a Solution

Comments

PIEBALDconsult 20-Nov-14 15:20pm

You mean you want to set a time-out? That can probably be done in code. We would need to know what database system you're using to be more helpfull.

PhilLenoir 20-Nov-14 15:37pm

If your DBMS/connection capability doesn't allow you to set a time-out but you are working in a multi-thread tool you could fire the query on a thread and kill the thread if it does not return in time.

You don't say what your DBMS is or what your programming toolset is.

AJain07 20-Nov-14 16:24pm

Actually I am working on Sybase16 which is kind of same as SQL queries. We have stored procedure which is called by VB6 code.
I am looking is something can be by system level configuration. I would not like to jump in VB6 code.

Jörgen Andersson 20-Nov-14 17:18pm

That's a bit of a problem then, you need to send AQT Cancel Task in a separate thread.

AJain07 20-Nov-14 17:22pm

Is it not possible that i will attach some timeout with query while sending for execution?

Jörgen Andersson 20-Nov-14 17:32pm

None I know about.

Maciej Los 20-Nov-14 16:38pm

Create a job

Herman<T>.Instance 20-Nov-14 17:36pm

good one!

Thava Rajan 3-Dec-14 22:45pm

is that you want to run a query repeatedly for your mentioned time frame? or a for a single execution it take that much time

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2014-11-21T09:30:00

For Sybase database you need to install Job Scheduler to be able to create schedule (job).

Have a look here: http://www.experts-exchange.com/Database/Sybase/Q_25357412.html[^].

Official documentation: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc20001.1570/pdf/jsusers.pdf[^]

danielsql · Answer 2 · 2014-11-27T09:32:00

Solution 2

Can you specify which database are you using?

For SQL Server you can find an answer here:

http://stackoverflow.com/questions/7653880/t-sql-stop-query-after-certain-time[^]

Posted 27-Nov-14 9:32am

danielsql

AJain07 · Answer 3 · 2014-12-03T12:28:00

Solution 3

Hi Daniel,

I am using Sybase16

Posted 3-Dec-14 12:28pm