cherokee
14th December 2018, 02:47
Hello all,

we are running a session that selects data by range of items and dates, when run it manually, comes with the expected results, when in a job comes with way less data.

My hunch is that something to do with utc date, we put the current date + 120 days in both manually and in the job. :confused:

Any input will be greatly appreciated.

Thanks in advance,

jeffersyuan
14th December 2018, 03:11
Maybe you should check the job user default setting for the job session.

cherokee
21st December 2018, 23:49
Thank you, found the problem. the init.form is not executed on the job, therefore was not reading a table, I changed it and worked.

Thanks