Difference between  'Delayed Delete User' and  'Disable/Delete User After End Date' OIM Scheduler jobs.

 

We have 2 OIM Scheduler Jobs.
 'Delayed Delete User'
 'Disable/Delete User After End Date'

Here is the difference:
1. When User is having, default xL.UserDeleteDelayPeriod  = 0,
   and user reaches end date, then after running 'Disable/Delete User After End Date' job, user will removed/Deleted.
   or
   When we click 'Delete User' from UI user will be in DELETED state.

  Note: 'Disable/Delete User After End Date' job looks only for records who have USR_AUTOMATICALLY_DELETE_ON is NULL and STATUS != DELETED

      

SELECT USR.USR_KEY,usr_end_date,USR_STATUS  FROM USR WHERE
USR.USR_STATUS IS NULL OR UPPER(USR.USR_STATUS) != (UPPER('Deleted'))
AND ( USR.USR_END_DATE IS NOT NULL AND USR.USR_AUTOMATICALLY_DELETE_ON IS NULL )
AND usr.usr_end_date <=  to_date('2015-09-28 23:59:59','yyyy-mm-dd hh24:mi:ss');

2. When User is having, default xL.UserDeleteDelayPeriod  = 10, or not other than Zero then,
   If user reaches end date, then after running 'Disable/Delete User After End Date' job, user will be in DISABLED state
   and USR_AUTOMATICALLY_DELETE_ON will be populated to EndDate+xL.UserDeleteDelayPeriod.
   User will not be removed/Deleted instead it will be in DISABLED state.

   Once the USR_AUTOMATICALLY_DELETE_ON is reached/exceeds today date, 'Disable/Delete User After End Date' will no delete.
   because of Note mentioned in point 1.

   To delete such users we need to run Job 'Delayed Delete User' which deletes records where
 USR_AUTOMATICALLY_DELETE_ON IS  NOT NULL  and  STATUS = DISABLED.

SELECT USR.USR_KEY,USR_END_DATE,USR_STATUS  FROM USR WHERE
USR.USR_STATUS IS NULL OR UPPER(USR.USR_STATUS) = (UPPER('Disabled'))
AND ( USR.USR_END_DATE IS NOT NULL AND USR.USR_AUTOMATICALLY_DELETE_ON IS NOT NULL )
AND usr.usr_end_date <=  to_date('2015-09-28 23:59:59','yyyy-mm-dd hh24:mi:ss');