Hi,
We are having reports with pivots which are refreshed using huge data sources(.xlsx, .sas7bat (sas dataset), MDB files).
For refreshing the same reports we are having excel tools created using VBA.
We tried by scheduling the VBScript which will trigger the VBA macro using Autosys scheduler. For smaller data source (less than 50MB) the jobs are running successfully.
When we use the data sources more than 50 MB size, the autosys job is failing. The same report is running through command prompt without any failure.
Could you please help me to identify the issue??? Do we need to enable any settings in Autosys for larger files???
Thanks in advance
Vinoth
We are having reports with pivots which are refreshed using huge data sources(.xlsx, .sas7bat (sas dataset), MDB files).
For refreshing the same reports we are having excel tools created using VBA.
We tried by scheduling the VBScript which will trigger the VBA macro using Autosys scheduler. For smaller data source (less than 50MB) the jobs are running successfully.
When we use the data sources more than 50 MB size, the autosys job is failing. The same report is running through command prompt without any failure.
Could you please help me to identify the issue??? Do we need to enable any settings in Autosys for larger files???
Thanks in advance
Vinoth
Last edited: