开发者

How to get details about the DTS Step in a running job?

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 Jo开发者_如何学Pythonb 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?


You can add something which can show you where the dts currently running at. I prefer best way is to put alert using 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.


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.


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜