SQL作业无法正常工作 [英] SQL Job not working properly
本文介绍了SQL作业无法正常工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
大家好,
我在运行SQL作业时遇到问题。它在测试服务器中正常工作,但不能在Live中工作。
i附上了执行一次后获得的历史记录的细节。
Hello all,
I am facing a problem in running an SQL Job. it is working correctly in the test server but not working in the Live.
i have attached the details of the history obtained when executed once.
Date 12/17/2012 2:00:00 PM
Log Job History (AC_Admin_Resend_Notification)
Step ID 0
Server SCHEDULER
Job Name AC_Admin_Resend_Notification
Step Name (Job outcome)
Duration 29.11:31:44
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
The job was stopped prior to completion by User SCHEDULER\acserver. The Job was invoked by Schedule 9 (Admin_Resend_Every_Minute). The last step to run was step 1 (Admin_Resend)
。
有人请求帮助我。
谢谢你
Sijo
.
Some one pleas help me.
Thank You
Sijo
推荐答案
你好,
你试过运行该用户下的测试服务器上的作业中的代码?这可能是一个权利问题。尝试单独运行每个步骤,以便更容易识别错误所在。
Hi,
Have you tried running the code in the job on the test server under that user? It could be a rights issue. Try running each step separately to make it easier to identify where the error lies.
这篇关于SQL作业无法正常工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文