The requirement is to create one zip file which has pdf files and xml metadata of the all Work objects created in a biz day and save this generated zip file into external system server location allowing them to extract and read those unzipped pdf and xml files. The req is to zip everything into one single zip file and save this into server shared drive location.Will there be any caveat as we expect the size to be in between 200 to 300 MB?
I am not clear on what your spefic question is and its context. In general we have a number of best practices that should be followed when moving data from a production system. Please see PDN PegaRULES Database topics including purging and archiving: https://pdn.pega.com/browse/prpc-topics/pegarules-database.
For your requirement as stated above that you want to create zip file containing pdf files and xml metadata, whether the pdf files are attachments of the work object and what would be the content of xml metadata whether it is case content?
you can write an agent activity run after end of business hours may be 6pm daily and get the list of cases created on that day i.e. pxcreatedatatime and iterate on each of case from the list and open each case and get the attachment available on the case and store in the server directory, similarly for xml data.
After all the cases on that day are completed i.e. after that iteration completes in that activity write code for creating zip file.