Is it possible to export the table records daily through schedule job?

[Sathwik1]

I need to run a job daily, which needs to export the data(in incident table) as an XML and needs to trigger an email to x,y persons with that attachment..

is it possible>?

@Ankur Bawiskar 

[Ankur Bawiskar]

Hi,

you can get the record sysId of "ecc_agent_attachment" and query in "sys_export_set_run" and from there you can know which export set it is.

You can use after insert BR on ecc_agent_attachment table and use event based notification. In that BR script you check which export set it is and based on that trigger the relevant email.

I believe the attachment is there in sys_attachment and a reference is just placed in that field.

Did you open the record into ECC_Agent_attachment and check file is attached to that record?

If yes then include attachment checkbox on notification on this table should work fine.

[Ankur Bawiskar]

@Sathwik1 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.