dbTalk Databases Forums  

Executing Process Task Through Scheduled Job fails

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Executing Process Task Through Scheduled Job fails in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rmcompute
 
Posts: n/a

Default Executing Process Task Through Scheduled Job fails - 11-07-2006 , 07:42 AM






I created a DTS job which executes a Process Task. It is set up as follows:

Win32Process: \\us.ricoh.ds\rfg\nj02\shared\service\D1
RefreshLogs\Jobs\DelLogFiles.cmd
Parameters: Atlanta
Return Code: 0
Timeout: 0

The DelLogFiles.cmd batch job deletes the error logs from the prior job run.
When I run the DTS from Enterprise manager, it ends successfully and the
error logs are deleted. When I run as a scheduled task, it ends successfully
but the error logs are not deleted. Since the application is able to
transmit data to the directory containing the error logs, I assume it would
not be a security issue in accessing the batch command. Does anyone have any
ideas what it could be ?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.