|
My organization DBA person has left from company. He was created the 5 jobs.I am a new dba i have a sysadmin role but last week we faced the non logged agent shutedown error in one snapshot replication job . so i logged in and reinitilized the subscription in my login. then runs the job it suceeceds. but my problem is next week previous DBA created 4 jobs and replication snapshot 1 jobs totally 5 jobs are throw the error as Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account.
Above Error came for following failed job list:(All of the jobs created by previous dba and executed by me) Weekly log file shrink Weekly index rebuild Weekly statistics update Weekly log file shrink one db Live machine one db copy to Dev machine Live machine one db snapshot to Dev machine what is the solution???
(comments are locked)
|
|
You need to add your account in as a sysadmin, and or create a proxy account which has the correct permissions and tell the jobs to run via the proxy account instead of the calling user. The issue boils down to the fact that your account is not privledged enough to run the jobs in question. hi anthony, green my account had already sysadmin permission. but i dont know proxy account whether is it or not. how to set this????????
Dec 11 '12 at 10:51 AM
askmlx121
Check the privledges of the account which the agent is running under. This link will help on creating proxy accounts Proxy Accounts
Dec 11 '12 at 11:22 AM
anthony.green
(comments are locked)
|
