Hey Buck,

Execute As -- So, here is the short description: It will work for the SPID it is created for.

An example: When you open a tab for a new query you get spid (59) next one is something like (60) right? Basically when you use the Execute As that will work only in the scope of the "tab" it is called in.

So for your use case: If you place that code as part of the job, that will persist for the job itself.

The only issue you MIGHT run into is that Execute As not lasting as long as you want, in other words getting out of scope.

Let me know if I can clarify anything!

Jeremy