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???
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.
answered Dec 11, 2012 at 10:34 AM