Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kathir
Starting Member
1 Post |
 Posted - 2014-03-31 : 12:33:38
|
| Hi All,We are trying to use SQL Server Agent to trigger the jobs. File archiving is done through a package . And When the package is run separately , Archiving the file is successful. But when we run thru the Agent , the job fails. The error faced is " Access denied to the folder". The folder permissions were changed and the job was triggered again. The job was successful. But when we trigger again the JOB fails.The folder permission changes everytime.Can u pls suggest ur views on this?thanks,kathir |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-03-31 : 13:12:32
|
quote:
Originally posted by kathir
Hi All,The folder permission changes everytime.thanks,kathir
If that is true, then you have bigger problems.Realistically, you need to grant permissions to whatever is running the Job. By default I think it is SQLSERVERAGENT, but you'd need to check in your environment. |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-04-01 : 10:32:54
|
| Use a credential to run the jobs and then make sure you have a local admin account on the server with the correct permissions to modify files...We are the creators of our own reality! |
|
|
|
|
|
|
SQL SERVER AGENT