I have set up a DTS to run from a scheduled job. I have several steps in the DTS. Now whenever the job is going on and I put a look at the section of the jobs in the Enterprise Manager, it always displays the following in the situation: executing the work phase 1. However, to execute all its steps properly Know what steps DTS is going on?
Can I get status from SQL Analyst?
You can add something that can show you that currently DTS is running I like best by using a script, alerts is inserted, there is no other direct way that you can detect DTS work!
Comments
Post a Comment