Job fails due to execute process task on sql server agent

• jasminipatel51181

  SSC Veteran

  Points: 264

  More actions

  March 21, 2012 at 9:15 pm

  #255171

  Hi ,

  I have an issue with the SQL Server Agent job . My Package runs fine on BIDS but fails when I schedule it .

  Error Message on Job:

  1. Error Code : 0xC002913

  Source : ReName Knewton’s file Execute Process Task Description : File/Process “Knewton.bat” does not exist in directory “C:/users/jpatel/Batch files/Knewton.bat”

  2. Code : 0xC0024107

  Description : there were errors during task validation.

  Please provide me any solution as soon as possible .

  Thanks,

  J

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  March 21, 2012 at 9:34 pm

  #1462512

  When you run the SSIS package in BIDS, is this on the server itself or on a separate PC (workstation)?

• jasminipatel51181

  SSC Veteran

  Points: 264

  More actions

  March 22, 2012 at 8:20 am

  #1462741

  Hi Lynn,

  Thanks for the Reply.

  It is on server itself.

  Thanks,

  Jasmini