DBA Data[Home] [Help]

APPS.IEM_CLIENT_PUB dependencies on IEM_AGENT_SESSIONS

Line 3424: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days

3420:
3421: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3422: delete from iem_rt_media_items where expire = 'Y';
3423:
3424: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3425: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3426:
3427:
3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days

Line 3425: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;

3421: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3422: delete from iem_rt_media_items where expire = 'Y';
3423:
3424: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3425: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3426:
3427:
3428: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3429: