Scheduled DTS Job To Run A Cmd File Not Working

Hi,

I have created a DTS job that contains one 'Execute SQL Task' job. This SQL task runs a cmd file. The cmd file runs a few windows commands and then runs a Micorosoft Access Macro. Once finished both access and the cmd screen close down.

If I open up the DTS job and execute it manually, it works fine (takes about 1/2 an hour to run). My problem is that when I schedule the DTS job, the job starts up at the correct time but it never actually starts running the cmd file and it gives no error. It says Executing until I actually stop the job manually.

The Job details are:

Type: Operating System Command [CmdExec]

Command: DTSRun /~Z0x2F3FF84472BB6E7FF356EB006BA1AEC62C95AB3BF506F3 4A241F228CE148AB09DBC66B8651A450B725E6C4E6A1D328E4 EC2F2C0F8E323F1C7D501FD5B8FD00E25656514AF2224407DB 1C569163CBE383A8E7D8BE4974A0911F5CEB

The DTS details are:

C:BatchesDTSrunofUpdatesqlpmi.cmd

The cmd program details are:

echo on
:Start

if not exist "c:appsCI_Databasespmipmiload.mdb" exit

rem cleanup unfinsihed runs
if exist "c:appsCI_Databasespmipmiload.mdb" if exist "c:appsCI_Databasespmipmiloadold.mdb" del "c:appsCI_Databasespmipmiloadold.mdb"

rem main file locked assume its being work on so don't run this job.
if exist "c:appsCI_Databasespmipmiload.ldb" exit

rem if a tmp exits then the last job never completed - continue to add to tmp file

if exist "c:appsCI_Databasespmipmiloadtmp.mdb" goto Load

copy "c:appsCI_Databasespmipmiload.mdb" "c:appsCI_Databasespmipmiloadtmp.mdb"

:Load
"C:Program Filesmicrosoft office 2003OFFICE11msaccess.exe" "c:appsCI_Databasespmipmiloadtmp.mdb"/x updatedata
rem Compact databases
"C:Program Filesmicrosoft office 2003OFFICE11msaccess.exe" "c:appsCI_Databasespmipmiloadtmp.mdb"/compact

ren "c:appsCI_Databasespmipmiload.mdb" "pmiloadold.mdb"
ren "c:appsCI_Databasespmipmiloadtmp.mdb" "pmiload.mdb"
if exist "c:appsCI_Databasespmipmiload.mdb" if exist "c:appsCI_Databasespmipmiloadold.mdb" del "c:appsCI_Databasespmipmiloadold.mdb"


All help is greatly appreciated as this has been bugging me for some time now.

Thanks
Sam