force all jobs to be created with SA ownership

Last Post 03 Dec 2008 10:33 PM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
bdnoble
New Member
New Member

--
03 Dec 2008 05:12 PM
For reasons to complicated to go into here, I need to make sure that all jobs that are created in SQLAgent are owned by SA. Does anyone know if there is a way to force this to happen rather than the id that is actually creating the job?

Any help is appreciated
SwePeso
New Member
New Member

--
03 Dec 2008 10:33 PM
Yes. You can create a trigger on sysjobs table and update owner_sid column.
You are not authorized to post a reply.

Acceptable Use Policy