Scheduler Heart Beat job is Deleted/Cancelled, how to set it back?

Products

• Clarity PPM On Premise

Issue/Introduction

The Scheduler Heartbeat job was possibly cancelled and deleted from the Scheduled job list. Looking in CMN_SCH_JOBS, it's not scheduled. How can we set it back?

Cause

The Scheduler Heartbeat job was visible in the Scheduled Jobs screen in the UI in older Clarity versions. So most likely it was deleted back in the time it was visible.

In recent versions of Clarity this job is not visible in UI, so it could not have been deleted from the UI. 
 

Resolution

Check whether the Scheduler Heart Beat job is scheduled in CMN_SCH_JOBS table by running the query:

• select * from cmn_sch_jobs  
  where job_definition_id in 
  (select id from cmn_sch_job_definitions where job_code  ='job_check_heart_beat')

If it's not set to SCHEDULED or no results are returned, then this is an issue. 

If it's Scheduled, then it's all good. 

If the job is not scheduled do the following:

1. Please run the following query to make it visible in the UI:
   • update cmn_sch_job_definitions
     set is_admin_visible = 1
     where job_code ='job_check_heart_beat' ;
     commit ; 
2. Go to Home - Reports and Jobs and schedule the job JS Heartbeat accordingly as cron tab  * * * * * (every minute)
3. Once done, hide the job definition as well as the scheduled execution : 
   • update cmn_sch_job_definitions
     set is_admin_visible = 0
     where job_code ='job_check_heart_beat' ;
     commit ; 
   • update cmn_sch_jobs
     set is_visible = 0 
     WHERE job_definition_id in (select id from cmn_sch_job_definitions where job_code ='job_check_heart_beat'); 
     commit; 

Additional Information