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

Question

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?

Answer 1

The display you get is a snap shot. you need to keep refreshing it.

Answer 2

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.

Answer 3

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.