Eddie Monster
14th June 2002, 23:42
We have a defined login of 'Batchjob' as a unix and baan user that we use to run jobs for Job Management.
One such 'batchjob' that runs under job managment runs all of our Work-In-Process reports for Finance's month end (the Job is called WIP).
This WIP job runs all inventory reports for all of our divisions (Pennsylvania and Arizona). These reports take several hours to run due to our heavy use of projects (not 'big' projects) and the number of transactions in our integrations table and will continue to take several hours until we archive.
Our Finance department would like to be able to have the batchjob print one full set of reports in Pennsylvania and have duplicates of the Arizona set print in Arizona. Since the reports that print are 'owned' by the 'batchjob' user, other users cannot re-print the job through Maintain Device Que.
Does anyone know of a way to get the reports to print without creating another batchjob user or Job Managment job?
Constraints:
We do not want anyone outside of our IT department to have rights to the 'batchjob' user for obvious reasons.
Due to the amount of time it takes for the reports to run we don't want to have to re-run the same reports. Additionally when the reports are run by 'batchjob' we have some coding that causes tables to be populated when we calculate an automatic WIP Accrual and an automatic reconciliation to our GL detail that will be double populated if 'batchjob' runs the job twice.
We don't want someone from IT to have to log into baan manually as batchjob to reprint these reports everymonth.
Any ideas?
One such 'batchjob' that runs under job managment runs all of our Work-In-Process reports for Finance's month end (the Job is called WIP).
This WIP job runs all inventory reports for all of our divisions (Pennsylvania and Arizona). These reports take several hours to run due to our heavy use of projects (not 'big' projects) and the number of transactions in our integrations table and will continue to take several hours until we archive.
Our Finance department would like to be able to have the batchjob print one full set of reports in Pennsylvania and have duplicates of the Arizona set print in Arizona. Since the reports that print are 'owned' by the 'batchjob' user, other users cannot re-print the job through Maintain Device Que.
Does anyone know of a way to get the reports to print without creating another batchjob user or Job Managment job?
Constraints:
We do not want anyone outside of our IT department to have rights to the 'batchjob' user for obvious reasons.
Due to the amount of time it takes for the reports to run we don't want to have to re-run the same reports. Additionally when the reports are run by 'batchjob' we have some coding that causes tables to be populated when we calculate an automatic WIP Accrual and an automatic reconciliation to our GL detail that will be double populated if 'batchjob' runs the job twice.
We don't want someone from IT to have to log into baan manually as batchjob to reprint these reports everymonth.
Any ideas?