DBA Data[Home] [Help]

APPS.IEM_CLIENT_PUB dependencies on IEM_AGENT_SESSIONS

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

3482:
3483: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3484: delete from iem_rt_media_items where expire = 'Y';
3485:
3486: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3487: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3488:
3489:
3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days

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

3483: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3484: delete from iem_rt_media_items where expire = 'Y';
3485:
3486: -- Delete each record from iem_agent_sessions where last_update_date is older than 30 days
3487: delete from iem_agent_sessions where SYSDATE - LAST_UPDATE_DATE > 30;
3488:
3489:
3490: -- Delete each record from IEM_MC_CUSTOM_PARAMS and IEM_MC_PARAMETERS where last_update_date is older than 30 days
3491: