Post reply

SQLSERVERAGENT How to create Command File

  • September 28, 2007 at 7:03 am

    #120623

    Hello Again,

    Does anyone know how to create a command file under the step section for a Sql Server Agent Job? I have an attached file with screenshot.

  • September 28, 2007 at 7:09 am

    #737101

    You have selected the wrong job type. Your job type is for running an SSIS package. To run a batch file or a command line, choose the Operating System (CmdExec) job step type.

  • October 1, 2007 at 6:22 am

    #737666

    Please give me an example...

  • October 1, 2007 at 6:48 am

    #737676

    In the Job Step Properties dialog, change the Type value to "Operating system (CmdExec)" and put the command you want to run in the Command text box.

  • October 1, 2007 at 7:02 am

    #737681

    Thank you for you response and example. I am currently testing and I will let you know the outcome, again thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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