Re-scheduling jobs when a person leaves
When a person leaves the group, we need to cancel and reschedule their PENDING jobs to an active employee. If there are a lot of scheduled jobs, this turns into a big effort. We take each job, make notes about parameters and run-time, cancel it, and re-schedule it. It's very tedious and prone to a few mistakes.
Having gone through one of these efforts, I'm wondering if there is an easier way? Is there a way to simply replace the original submitter's User ID with a co-worker's User ID--either by a screen, CM job, or special SQL?