I mistakenly thought that I would be able to go to Monitoring > Scheduled Jobs page and use the 'Submitted by' column to tell me which report schedules would be problematic when we deactivate a user.
The problem that I'm having is that when diving into the Scheduled report details it has a different "Running User" than what is displayed on the "Submitted By" column for the scheduled jobs page.
Monitoring > Scheduled Jobs - Unconverted Hot Leads (3+ Days Old):
Scheduled Report Details - Unconverted Hot Leads (3+ Days Old):
I don't want to have to go into each scheduled report every time we deactivate a user and check if the two user lookups are different. SOQLing on the CronTrigger only provides OwnerId (report owner), LastModifiedById (user who submitted the schedule). It doesn't appear to show any details around the "Running User". Any thoughts? This seems crazy!