Post reply

Run SQL Server Agent job from the command line

  • September 11, 2008 at 7:12 am

    #382621

    We have a SQL Server Agent job that is scheduled 3x per day. This job processes data from an AS400. Occasionally the AS400 gets backed up and doesn't populate the table my job needs before my job runs.

    I would like to be able to write a batch file/command line for the user to be able to run the job at will.

    Can this be done via a command line? If not, I would be interested in hearing what functionality you would use to accomplish this.

    Thanks,

    Bob

  • September 11, 2008 at 11:05 am

    #870494

    What is the job doing to process the AS400 data? If its calling a DTS package, BCP or using SQL statement(s) you might be able to extract out the job steps to a .bat file and execute that from the command line.

    _____________________________________________________________________
    - Nate

    @nate_hughes

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

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