Error in scheduled jobs: permission on DBCC TRACEON is missing V2014
Symptoms
The job history display in SQL Management Studio shows errors in some jobs.
Executed as user: CPSQLUser. User 'CPSQLUser' does not have permission to run DBCC TRACEON
Reason
The scheduled jobs normally run with system privileges and not as CPSQLUser (or CPAdmin / CPUser). That user is used to run the web site and does not have (and does not need) any system privileges.
Resolution
The scheduled jobs normally run with system privileges and not as CPSQLUser (or CPAdmin / CPUser). That user is used to run the web site and does not have (and does not need) any system privileges.