SQLServerAgent permissions -
08-20-2003
, 03:49 PM
I am attempting to run a VBScript via a scheduled Job
that checks for the existance of a text file on a network
share and deletes it if present. While the job runs and
reports it succeeded, the file remains in the directory.
This is a SQL Server 2000 SP3a installation on a Windows
2000 server (can be replicated on an XP machine as
well). I can execute the same VBScript outside of SQL
and it works correctly. I've found a number of postings
that discuss the need for the service startup account for
SQLServerAgent to have sufficient priveleges to the
network share where the file resides. I've checked and
double checked this and can't seem to see why it is not
executing. I've checked the event logs in Windows 2000
as well as the Agent error log and SQL Server logs. I
see no entries corresponding to the execution of this
script.
Can anyone help? |