Deleting files on a remote server w/sql agent ????

[Jim]

SQL 7.0

Hello,
I'm trying to delete files on a remote server thru a job step on one of my
DB Maintenance plans. I can copy files remotely, no problem, but if I want
to delete those same remote files it fails every time. I've tried the DEL
command and a batch file approach. Nothing works.

On a positive note, I can run the batch file from the command prompt outside
of SQL and it works fine.

Is this a security issue... I would appreciate any help.

thanks,
Jim

[Scott]

Jim,
Try checking to see if you run the batch file with the same user that
the SQL agent service is running under (check in Control Panel (Administrative
Tools) Services. If it is loggin in as local system account, then you are
most likely running into a permissions issue (the remote Folder probably
allows the "Everybody" group to add files, but restricts the delete permissions
(you may also need to check the NTFS permission if they are being used).
To correct this, you must create, or use an existing, account with permissions
to do the delete. Then set the Service to run under that account name.
This problem is also typically seen when trying to set up SQL Mail. Hope
that helps...

Scott

"Jim" <jfarrell@hackley.hbocvan.com> wrote:
>
>SQL 7.0
>
>Hello,
>I'm trying to delete files on a remote server thru a job step on one of
my
>DB Maintenance plans. I can copy files remotely, no problem, but if I want
>to delete those same remote files it fails every time. I've tried the DEL
>command and a batch file approach. Nothing works.
>
>On a positive note, I can run the batch file from the command prompt outside
>of SQL and it works fine.
>
>Is this a security issue... I would appreciate any help.
>
>thanks,
>Jim