well, first you should be scheduling important jobs as a service account instead of user accounts for exactly this reason...
right now the only supported way is to remove the schedule and re-create it as the new user.
I've done this in the past using SQL queries, basically you need to change the created_by_user_id and created_by_role_id values of the schedules to the new user/role you want. The thing is doing it only for the right schedules (i.e. future ones for jobs saved explicitly, etc...).
It can be done by Set Execution Override option.
You'd have to set an exec override on every job that has a schedule for which you want to change the user though, and any modification to the job using a different role would break it, so not ideal...
Yep, we ran into this one as well (when a guy moved 'north'... )
I thought about a process to:
- list all scheduled jobs
- grab the schedule info
- re-create via BLCLI using a 'service type' account (as Bill suggested)
But, I have not done this; we manually re-scheduled the jobs...
Also, we thought about creating an internal (SRT user) for scheduled jobs - anyone else doing this?