local package with batch file not running when using job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » local package with batch file not running...

local package with batch file not running when using job

Rate Topic

Display Mode

Topic Options

Author

Message

mel-1009375

Posted Thursday, February 05, 2009 8:17 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 11, 2009 11:40 PM
Points: 6, Visits: 37

Hi,

I'm encountering a problem when I use batch file in local package and run this as job. I created a local package using the execute process task with the batch file (contains script where it will open an application automatically) attached to it. When I execute this local package manually, the batch file works. But when I scheduled it nothing happens. The application in the batch file doesn't open. How can I solve this?

thanks,

mel

Post #651380

mel-1009375

Posted Thursday, February 05, 2009 8:34 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 11, 2009 11:40 PM
Points: 6, Visits: 37

Hi,

During the scheduled run this error appears:
'DTSRun.exe - Application error : The application failed to initialize properly (0xc0000142). Click on OK to terminate the application.'

The batch file contain the following script:
CD C:\Program Files\Microsoft Dynamics\GP
START Dynamics.exe Dynamics.set LoginGP.mac

How can I solve this?

Post #651382

« Prev Topic | Next Topic »

Permissions