Unable to delete recurring series job

Products

• VMware Smart Assurance
• Network Observability

Issue/Introduction

When user is attempting to remove recurring series job, error "Failed to retrieve Tasks associated to Job" is observed.

Clicking Details would give exception as "com.powerup.configmgr.server.services.scheduler.SchedulerException: SchedulerException.FindTasksForJobFailed"

Environment

NCM - 10.1.x/24.3.x

Cause

Task for recurring series job is not available in DB.

Resolution

Delete problematic job from DB as:

1. Set job to hold:

   UPDATE cm_job SET status = 'enum.taskStatus.hold' WHERE job_number='<enter job number>';

   Example:
   

   UPDATE cm_job SET status = 'enum.taskStatus.hold' WHERE job_number='10947297';

2. Delete the job:

   UPDATE cm_job SET status = 'enum.taskStatus.deleted' WHERE job_number='<enter job number>';

   Example:
   

   UPDATE cm_job SET status = 'enum.taskStatus.deleted' WHERE job_number='1094727';

3. Confirm by refreshing view in GUI that all jobs are deleted.