locked
Scheduled job Step Output to Job History RRS feed

  • Question

  • Hi

    I've been looking at kb 918760. In this, it says

    "You can also use the Include Step Output in the history option to redirect the logging information to a file or to the SQL Server Agent Job History."

    Now I'd really like to do this, but can't see this option anywhere nor can I find any reference to it in the help.

    Can anyone point me in the right direction?

     

    Regards

     

    Guy

    Tuesday, July 25, 2006 6:56 AM

Answers

  • This option is available when you use CmdExec Subsystem to execute your step, instead of SSIS Subsystem.

    From KB:

    About the exec subsystem command and output information

    By using the exec subsystem command approach, you add verbose console logging switches to the SSIS command line to call the Dtexec.exe SSIS command-line executable file.
    Tuesday, July 25, 2006 7:09 AM

All replies

  • This option is available when you use CmdExec Subsystem to execute your step, instead of SSIS Subsystem.

    From KB:

    About the exec subsystem command and output information

    By using the exec subsystem command approach, you add verbose console logging switches to the SSIS command line to call the Dtexec.exe SSIS command-line executable file.
    Tuesday, July 25, 2006 7:09 AM
  • Doh!

    Suspected it might be something like this ...

    Thank you

    Tuesday, July 25, 2006 7:20 AM