Data archive to Azure

@JannetteC 

Hope this will give you some guidance

https://docs.ifs.com/techdocs/foundation1/040_administration/260_data_management/020_data_archiving/220_large_volume_media_archiving/default.htm

Regards,

Sahan

Hello @Sahan Udana 

Thanks for your reply.  I have media arching setup - however the CLU’s that I am trying to move to Azure have not moved despite me setting the job as follows:

Should I be using another method such as Data Archive Objects ??

Can you check if the below query returning any results.

SELECT   t.item_id, NULL language_code, t.media_object, t.archive_no
         FROM     MEDIA_ITEM_TAB t
         WHERE    t.latest_access_date < (SYSDATE - 30)
         AND      NVL(Dbms_Lob.GetLength(t.media_object),0) > 0
         AND      t.archived = 'FALSE'
         UNION ALL
         SELECT   l.item_id, l.language_code, l.media_object, l.archive_no
         FROM     MEDIA_ITEM_LANGUAGE_TAB l
         WHERE    l.latest_access_date < (SYSDATE - 30)
         AND      NVL(Dbms_Lob.GetLength(l.media_object),0) > 0
         AND      l.archived = 'FALSE';

These are the records not accessed for 30 days (last_access_limit_days) will be archived. If this has no results returned archiving will not happen.