如何在SQL Server 2005中查找作业的状态(空闲，正在运行，已成功执行) [英] How to find the status of a job in sql server 2005 (idle, running, executed successfully)

问题描述

大家好，
我陷入了与sql server作业有关的问题，并且从4天开始苦苦挣扎.
我有一个游标来运行具有不同值的作业，并传递给每个游标记录的reportserver..subscriptions表中的parameter字段.
对于游标的第一条记录，其工作正常.
但是对于某些记录，该作业未执行，并且我收到错误消息，为
SQLServerAgent错误:运行作业C5E96594-9876-42FE-9324-5F6DF8F5CC0B(来自User)的请求被拒绝，因为该作业已经有来自User的挂起请求.

谁能告诉我如何在sql server 2005中检查作业的状态
谁能告诉我如何解决此问题
任何帮助将不胜感激..

谢谢
Narayana

Hi guys,
I am stuck in a issue with sql server jobs and struggling from 4 days.
i have a cursor to run a job with different values passing to the parameters field in a reportserver..subscriptions table for every cursor record.
for the first record of a cursor its working fine.
but for some of the records the job is not executing and i m getting the error message as
SQLServerAgent Error: Request to run job C5E96594-9876-42FE-9324-5F6DF8F5CC0B (from User ) refused because the job already has a pending request from User .

Can anyone tell how to check the status of a job in sql server 2005
can anyone tell How to resolve this problem
Any help will be greatly appreciated..

Thanks
Narayana

推荐答案

检查

Check this[^] out. Try at your own risk (I have no clue if this works!).
:)

这篇关于如何在SQL Server 2005中查找作业的状态(空闲，正在运行，已成功执行)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！