如何获取正在运行的作业中DTS步骤的详细信息？
我已安排 DTS 从计划作业运行。 DTS 有几个步骤。现在，每当作业正在运行并且我查看企业管理器中的作业部分时，它总是在状态中显示以下内容：正在执行作业步骤 1'...，尽管它正确运行了所有步骤。我如何知道DTS运行在哪一步？
我可以从 sql 分析器获取状态吗？
I have scheduled a DTS to run from a scheduled job. The DTS has several steps in it. Now whenever the job is running and I take a look at the jobs section in Enterprise manager, then it always displays the following in the status: Executing Job Step 1'.... although its running all steps properly. How do I know at what step the DTS is running at?
Can I get the status maybe from sql analyzer?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
您可以添加一些内容来显示 dts 当前运行的位置。
我更喜欢最好的方法是使用脚本发出警报。没有其他直接方法可以用来跟踪 DTS 任务！You can add something which can show you where the dts currently running at.
I preferbest way is to putalertusing a script. There is no other direct way using which you can trace DTS task !您得到的显示是快照。你需要不断刷新它。
The display you get is a snap shot. you need to keep refreshing it.
该作业只有一步，即运行 DTS 包的命令。
如果您想查看包中步骤的进度，则需要向 DTS 包添加一些内容，以在日志表中记录每个步骤的完成情况。
There is only one step in the job, the command to run the DTS package.
If you want to see progress of steps within the package, you need to add something to the DTS package to record each step as it finishes in a logging table.
由于 DTS 主要针对数据库表执行，因此在 SQLServer 端，如果您具有管理权限，您可以找到当前所有活动的会话、正在执行的语句等。 您可以在“管理”下作为“活动监视器”找到它。
Since the DTS mostly executes against database tables, on the SQLServer side you can find what all sessions are currently active, the statement it is executing etc if you have administrative privileges. You can find this under Management as Activity monitor.