Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Job fails due to execute process task on sql server agent Expand / Collapse
Author
Message
Posted Wednesday, March 21, 2012 9:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:15 PM
Points: 8, Visits: 63
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

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:44 PM
Points: 23,042, Visits: 31,566
When you run the SSIS package in BIDS, is this on the server itself or on a separate PC (workstation)?



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
Posted Thursday, March 22, 2012 8:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 1:15 PM
Points: 8, Visits: 63
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