dbTalk Databases Forums  

SQLServerAgent permissions

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQLServerAgent permissions in the microsoft.public.sqlserver.tools forum.



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

Default 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?

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.