How do you find the "old job owner", "old job created by" and "old job last updated by" to replace these with a new user. This may be needed if someone has left the company and any jobs are scheduled by them. The cmn job tables need to be updated, but how do you get the job sharing list SQL table?
Release : Any
Run the following query:
Database updates are not supported, so the one option would be to perform the below through the UI:
For scheduled reports, see: Transferring Ownership of Scheduled Report Jobs to Other Users in the Organization from Jaspersoft communities