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 |
|
PRobertshaw
Starting Member
1 Post |
 Posted - 2014-07-22 : 14:22:38
|
| I have a Job, let's call it J.J executes an SSIS package.I have 2 user accounts. One is a proxy, and one is a limited account which my web service uses to log in. Let's call them P and L respectively.L needs access to run J. When I set L as the owner of J, J is unable to execute the SSIS. It needs the proxy account.When I set P as the owner of J, L is unable to see or execute J.What's the easiest way to allow L to successfully run the job? |
|
|
sunder.bugatha
Yak Posting Veteran
66 Posts |
Posted - 2014-07-28 : 11:12:01
|
| Provide required access to L on MSDB database and set p as the owner of J and try to run the job.Hema Sunder |
 |
|
|
|
|
|
Give access to job owned by proxy account