A scheduled clean up job of an external identity source will not run. The job is listed in the Security Console under Administration > Batch Jobs, but the information in the Complete Date column never changes, so new scheduled clean up jobs do not run:
Running the Clean Up Unresolvable Users option completes successfully:
There is an old scheduled cleanup job stuck in the Scheduled Queue, which prevents new scheduled jobs of the same type from running.
Before completing the steps below, login to the Operations Console and take a backup of the RSA Authentication Manager database (Maintenance > Backup and Restore > Backup Now). Be sure to make a note of the backup password used for the backup. If the backup is saved to the local Authentication Manager server, copy the backup off the server and store in a secure location.
Optionally, the failed batch job for Unresolvable Users and User Groups Cleanup can be listed based on its ID. Running a SELECT statement where id='<id captured above>' can be run first to verify that this is the correct batch job.
db=# SELECT name, id, status, created_on, completed_on FROM rsa_rep.ims_batch_job where id='<id_captured_above>';
Now run the DELETE command to remove the scheduled batch job that never runs:
db=# DELETE FROM rsa_rep.ims_batch_job WHERE id=<id_captured_above>';
This SQL statement removes the particular scheduled batch job that never runs, now locate any stuck scheduled cleanup batch jobs.
Run a SELECT statement to locate all scheduled batch jobs:
db=# SELECT name, id, status, created_on, completed_on FROM rsa_rep.ims_batch_job;
Look for any scheduled Unresolvable User and User Group Cleanup jobs that do not have a status of 0. Typically stuck jobs will have a status of 2. These are the stuck scheduled cleanup jobs that are preventing the new scheduled cleanup from running,
Delete the stuck scheduled cleanup jobs, but test by running a SELECT on each job first, copying and pasting in the id for the specific scheduled batch job:
db=# SELECT name, id, status, created_on, completed_on FROM rsa_rep.ims_batch_job where id='<Unresolvable_Users_and_Groups_id>';
When ready, run the SQL command to delete the batch job:
db=# DELETE FROM rsa_rep.ims_schedule_job WHERE id='<Unresolvable_Users_and_Groups_id>';
The stuck jobs have been removed from the database. Try to run a new cleanup.