如何在给定时间内执行查询 [英] how to execute query within the given time

问题描述

大家好，



我想在给定的时间内执行sql查询。有人有任何参考。请让我知道。



提前致谢

Harshal

Hi Everyone,

I want to execute the sql query in the given time.Do anyone have any reference.Please let me know.

Thanks in advance
Harshal

推荐答案

您可以使用SQL作业调度。



您可以在存储过程中编写查询并在SQL JOB中使用SP。



查看此链接< br $> b $ b

http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/ [ ^ ]



http://www.youtube.com / watch？v = De_GOwnTDjo [ ^ ]



SQL Server代理的调度程序GUI [ ^ ]



http://sqlserverscribbles.com/2013/06/08/how-to-create-sql-server-agent-jobs / [ ^ ]



http://stackoverflow.com/questions/287060/scheduled-run-of-stored-procedure-on-sql-server [ ^ ]



http://stackoverflow.com/questions/ 1216272 / how-to-execute-a-stored-procedure-in-a-sql-agent-job [ ^ ]

You can use SQL Job scheduling.

you can write your query in Stored procedure and use the SP in your SQL JOB.

Check this links

http://www.c-sharpcorner.com/UploadFile/raj1979/create-and-schedule-a-job-in-sql-server-2008/[^]

http://www.youtube.com/watch?v=De_GOwnTDjo[^]

A scheduler GUI for SQL Server Agent[^]

http://sqlserverscribbles.com/2013/06/08/how-to-create-sql-server-agent-jobs/[^]

http://stackoverflow.com/questions/287060/scheduled-run-of-stored-procedure-on-sql-server[^]

http://stackoverflow.com/questions/1216272/how-to-execute-a-stored-procedure-in-a-sql-agent-job[^]

你可以处理在你的前端编程即定义查询超时，如果在那段时间内没有执行，它将给你超时错误。处理该错误并显示相应的消息。

you can handle that in your front end programming I.e. define the query time out and if that does not execute in that time it will give you timeout error. handle that error and display appropriate message.

这篇关于如何在给定时间内执行查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！