Windows Scheduled Tasks and Permissions
Posted on 2008-11-15
Here's my construct:
1. I created a BAT file named EXEC_spRTMaster.bat that calls a SQL Server command named SQLCMD (which in turn runs a sproc named spRTMaster). When called manually, the BAT file runs successfully.
2. I created a Windows Scheduled Task to call EXEC_spRTMaster.bat. When the Windows Scheduled Task is associated with account in Domain Admins, it runs successfully.
3. I created a Domain User account named RTScheduler. I gave RTScheduler full permissions to the Scheduled Task. I also gave RTScheduler full permissions to the folder containing EXEC_spRTMaster.bat.
4. Yet, when I run the Scheduled Task while its associated with RTScheduler as the user, EXEC_spRTMaster.bat does not run.
It seems like I still need to grant another permission somewhere? Or, perhaps there's another process (associated with a different domain account) that's sneaking into the process?