Job fails due to execute process task on sql server agent

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 7,2000 » SQL Server Agent » Job fails due to execute process task on sql...

Add to briefcase

Job fails due to execute process task on sql server agent

Expand / Collapse

Author

Message

jasminipatel51181

Posted Wednesday, March 21, 2012 9:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:22 AM
Points: 8, Visits: 54

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

Post #1270606

Posted Wednesday, March 21, 2012 9:34 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:46 PM
Points: 21,589, Visits: 27,392

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

Cool

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1270610

jasminipatel51181

Posted Thursday, March 22, 2012 8:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:22 AM
Points: 8, Visits: 54

Hi Lynn,

Thanks for the Reply.

It is on server itself.

Thanks,
Jasmini

Post #1270885

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse