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 |
|
ServerTeam
Yak Posting Veteran
83 Posts |
 Posted - 2008-05-06 : 15:44:43
|
| How can i fix a job to run with particular accountThanks,ServerTeam |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 15:47:29
|
| What do you mean? you mean user account. They have to have permission like 1)sysadmin ornew roles in msdb for running and manipulating. |
 |
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-06 : 16:01:06
|
created job with owner as SACCAP\svcNewHirePortalwhen i am staring job its executing with..Executed as user: SACCAP\svcSQLCTI want to execute job with SACCAP\svcNewHirePortal account..quote:
Originally posted by sodeep
What do you mean? you mean user account. They have to have permission like 1)sysadmin ornew roles in msdb for running and manipulating.
Thanks,ServerTeam |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 16:03:54
|
| Change owner to SACCAP\svcNewHirePortal and refresh job. |
|
|
|
ServerTeam
Yak Posting Veteran
83 Posts |
Posted - 2008-05-06 : 16:21:14
|
Even i find job running with SQL Agent service account..as SACCAP\svcSQLCTquote:
Originally posted by sodeep
Change owner to SACCAP\svcNewHirePortal and refresh job.
Thanks,ServerTeam |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 16:24:29
|
| what job contains? Try running job if not issues and check job history what do you see. Make sure change it to SACCAP\svcNewHirePortal |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 22:05:38
|
| Sql will run job under sql agent service account, but you can set proxy and put it in run as field. |
|
|
|
|
|
|
Running Job