SQL Server Performance Forum – Threads Archive
changing the owner of maint plan jobsWhen I created the maint plan , it doesnt ask me for the selection of owner of job which was created by this maint plan.I changed the owner of the integrity check job by EM to ‘sa’. The job failed with a error Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed..
I want to know how should change the owner to ‘sa’ for the jobs created by maintenance plans wizard.
Check if this problem is not related to yours. — Rediscover the web