DJH
Active Member
Hi
We have a requirement to email certain report pdfs to users once they have run them. To do this I have setup an SQL trigger on the SVM810.F986110 table, every time a row is updated and the status column is set to 'D' it gets the email address of the user and sends the pdf (which is also in the table). The email bit works fine but for some reason the runbatch.exe doesent terminate on the UBE Server. This obviously means that all other jobs stay at waiting status until I manually kill the runbatch.exe process. Obviously this is not ideal!
I have two questions:
1. Does anyone have any ideas why the runbatch.exe process is not terminating?
2. Is a trigger on the SVM810.F986110 the correct way to do what I want or will it cause problems?
I have seen an alternative way on JDEtips but it looks too complicated and this way seems far easier to implement.
Thanks in advance
We are on ERP8.10 running SQL2000, all Intel(Windows 2000 server).
We have a requirement to email certain report pdfs to users once they have run them. To do this I have setup an SQL trigger on the SVM810.F986110 table, every time a row is updated and the status column is set to 'D' it gets the email address of the user and sends the pdf (which is also in the table). The email bit works fine but for some reason the runbatch.exe doesent terminate on the UBE Server. This obviously means that all other jobs stay at waiting status until I manually kill the runbatch.exe process. Obviously this is not ideal!
I have two questions:
1. Does anyone have any ideas why the runbatch.exe process is not terminating?
2. Is a trigger on the SVM810.F986110 the correct way to do what I want or will it cause problems?
I have seen an alternative way on JDEtips but it looks too complicated and this way seems far easier to implement.
Thanks in advance
We are on ERP8.10 running SQL2000, all Intel(Windows 2000 server).