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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Trying to create a user to run sql server agent jo

Author  Topic 

csphard
Posting Yak Master

113 Posts

Posted - 2015-02-18 : 18:27:05
I created a user and mapped to the database.
Checked off db_datareader

Then I checked msdb and checked off SQLAgentUserRole

This allows me to start a New Job but when I go to Advance
I do not have access to the elipse for Output file.

What did I miss?

Howard

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-18 : 19:18:09
Probably needs permissions to the location of the output file on disk, though I'm not sure. Does it work for sysadmin users?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

csphard
Posting Yak Master

113 Posts

Posted - 2015-02-18 : 19:21:43
Yes, I can log on as sa and I have access to it. I was hoping to use another user and not sa to run this.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-18 : 19:30:29
I would investigate permissions on the disk then.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -