CODEWITHSUNDEEP
sqldts
vikasde
vikasde

Reputation: 5751

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 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?

Upvotes: 0

Views: 2091

Answers (4)

Code_Tech
Code_Tech

Reputation: 795

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 !

Upvotes: 1

A_Var
A_Var

Reputation: 1036

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.

Upvotes: 0

HLGEM
HLGEM

Reputation: 96580

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.

Upvotes: 0

zapping
zapping

Reputation: 4116

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

Upvotes: 0

Related Questions