Hi,
we are using the SAP SQL Connector to send some very long SELECT statements (each 24kB long) into the SAP system several times per day. This fulfills our purpose and is reasonably fast.
We now found out the hard way that Qlik stores every SELECT statement into the table /QTQVC/JOB_SQL for reasons that are not apparent to me. Since our statements are very long, they produce 100s of table entries per statement, adding up to roughly 2 Million entries per day.
Is there a way to stop the Qlik Connector from writing into this table? It is fast becoming an issue of storage space. We are aware that there is a Qlik transaction to delete records from past years but we are already having issues with records from this year. It is not recommended to delete those while a Connector job is running and it is quite hard to find a windows of time where this is definitely not the case.
Any help is very appreciated!
Michael
