dbTalk Databases Forums  

RE: Process Task Does Not Work as Scheduled Job

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


Discuss RE: Process Task Does Not Work as Scheduled Job in the microsoft.public.sqlserver.dts forum.



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

Default RE: Process Task Does Not Work as Scheduled Job - 12-11-2006 , 05:11 PM






It worked ! Thank you.

"RLoski" wrote:

Quote:
If T: is a mapped network drive, then the job is unlikely to know what "T:"
is. Try using a UNC and see if that will work.

I would have thought that this would have caused an error. But try my
suggestion and see if it works.

Russ

"rmcompute" wrote:

I set up a Process Task:

Win32Process: DelLogFiles.cmd
Parameters: Atlanta

The file DelLogFiles.cmd is:
:: DelLogfiles.cmd
@echo On
Del /Q T:\D1REFR~1\%1\*.*

The process works when I run it from Enterprise Manager deleting all log
files in the Atlanta subdirectory. However when I run it as a scheduled task
it does not delete the files, but ends successfully. If it were a security
issue, I would think it would have failed. Any ideas ?


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.