Post reply

DTS Step doesn't execute

  • March 21, 2003 at 5:07 pm

    #80480

    I have a package that executes and runs perfect when manually executed from EM. However, if I run the job it always reports failure on the same step.

    The step is an external program that runs. It's a 3270 session that when opened will automatically start a macro to go through the commands to run the report. IF I manually execute the package I can see the session open up run through the commands and close up. But since I can't see anything when the job executes using the SQL Agent I am not sure if the program is running the macro. or even starting up and running.

    I am using the exeternal app with a profile in the parameters option.

    Any ideas?

  • March 24, 2003 at 3:46 pm

    #451985

    What sort of "macro" are you running? Maybe it can be changed to write out status messages?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • March 26, 2003 at 12:56 pm

    #452217

    I figure it out. The problem was that at the time that I ran package the db was down.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply