Job "Sharing" list table with owner details

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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?  

Environment

Release : Any

Resolution

Step 1: Determine which jobs are scheduled by the user

Run the following query:

select J.STATUS_CODE, J.SCHEDULE_DATE, J.LAST_UPDATED_DATE, D.JOB_CODE, J.name, r.first_name, r.last_name, r.user_name, j.last_updated_by, j.created_by from

CMN_SCH_JOB_DEFINITIONS D, CMN_SCH_JOBS J, CMN_SEC_USERS R
where 1=1
and R.id = d.LAST_UPDATED_BY
and D.id = J.JOB_DEFINITION_ID
and J.STATUS_CODE in ('SCHEDULED', 'PAUSED', 'WAITING', 'PROCESSING', 'CANCELLED')
order by j.schedule_date

Step 2: Change the owner of the scheduled jobs to another user

Database updates are not supported, so the one option would be to perform the below through the UI:

1. Go to Reports and Jobs
2. Click on the Jobs tab
3. On the Jobs tab drop-down, select 'Scheduled Jobs'
4. Click on the job 
5. Take a screenshot (or notes) of the job settings including:
   • Parameters
   • When
   • Notify
   • Sharing
6. Click 'Return'
7. Select the job and cancel it
8. Recreate the scheduled job using the steps taken in #5 above. 

Additional Information

For scheduled reports, see: Transferring Ownership of Scheduled Report Jobs to Other Users in the Organization from Jaspersoft communities