如何检查当前正在运行的SQL Server作业。 [英] How To Check which SQL server Job is running currently.

问题描述

嗨那里，



我遇到一个场景，我的服务正在处理一些文件并将数据插入数据库，但在特定时间我们的SQL服务器工作是运行并且在此期间任何与数据库相关的操作通过服务失败抛出错误sql server超时错误。那么请你帮我避免在SQL服务器作业运行期间处理文件。

解决方案

增加 SqlCommand的超时 s或安排工作在非高峰时段运行。



编辑：

http://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL% 20Server％20Agent％20jobs.aspx [ ^ ]



http://stackoverflow.com/questions/18445825/how-to-know-status-of-currently-running-jobs [ ^

Hi There,

I am come across one scenario where my service is processing some file and insert data into database, but at particular time our SQL server job is running and during that any DB related operation through service gets failed throwing error sql server timeout error. So could you please help me to avoid processing of files during SQL server job is running.

解决方案

Increase the timeout for your SqlCommands or schedule the job to run at off peak times.

EDIT :
http://www.sqlmatters.com/Articles/Checking%20the%20status%20of%20SQL%20Server%20Agent%20jobs.aspx[^]

http://stackoverflow.com/questions/18445825/how-to-know-status-of-currently-running-jobs[^]

这篇关于如何检查当前正在运行的SQL Server作业。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！