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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2010-01-05 : 09:31:23
|
| Hello,I am trying to change the User name under which my created job is run under.i.e. in the General properties of the Step of the Job it shows run as: "SQl Server Service Account". I would like to change this to my username because my username has access to the file which the job uses whereas it seems the existing Run as user does not have permission to access the file.Any thoughts please?Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-05 : 11:25:40
|
| I'll give SQL Agent account permission instead.And leave the run as field blank in all job steps -- which defaults it to SQL Agent account. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2010-01-06 : 03:43:47
|
| Thanks |
|
|
|
|
|
|
job