Retention for Jobs and Sub-Jobs

Issue

The retention policy for Jobs is working but it seems not working for the sub-jobs created from the parent process (job). 

Cause

The sub-job created from the parent process job will never enter the completed status thus it cannot get archived.  It will always remain active.  However the sub-job will then get archived as part of the parent job when it completes.  This is expected behaviour.

Note: If there is issue to archive the parent job then naturally its sub-jobs were not archived.

Solution

Complete the parent job so that its sub-jobs will also get archived once it is due for archival (otherwise you could also manually trigger directly from Designer to see the result).

Please could use this package to test it as per summarized in the screen shot below.

• If you create a job based on this, it will run through and complete straight away.  Then run the below SQL against your finished jobs database.
• If you could not find the records then probably your system task to archive was not triggered yet then you could manually trigger directly from Designer.

SELECT JOB_ID, PROCESS_NAME, JOB_STATUS
FROM FINISHED_JOB
WHERE PROCESS_NAME IN ('Finished Parent Process', 'Finished Sub Process')

• You could see the parent job has status 1 which is completed
• The sub-job is having status 0 which is active.
• However both have been archived successfully.

Level of Complexity 

Easy

Applies to  

References

The below articles are good for understanding on retention

• Job Retention Policy
• In What Order Are KTA Archived Jobs and Documents Deleted