Hi James, We are solving that problem for a customer at the moment.
You could check if the batch user is logged on to the SQL server, only that will not give you the answer you are looking for. The user can be logged on, and the batch process has crashed, or the user is not logged on, but the batch process is running - but Idle. We decided to introduce a heartbeat to the batch process. After execution on the batch process we write a XML file with an execution log. The heartbeat is monitored a BizTalk server starting a workflow if the batch process has not been executed the last 10 minutes. Mit freundlichen Grüßen / Best regards / Med venlig hilsen Jesper Jørgensen / Abt. NMT-XD Senior Product Manager arvato systems | Technologies GmbH An der Autobahn 18 33311 Gütersloh jesper.joergen...@bertelsmann.de<blocked::blocked::blocked::mailto:jesper.joergen...@bertelsmann.de> Phone: +49 5242 / 40 80 54 Fax: +49 5242 / 40 80 40 Mobile: +49 172 / 571 03 34 http://www.as-T.de<blocked::blocked::http://www.as-t.biz/> arvato systems | Technologies GmbH Joachim-Jungius-Str. 9, 18059 Rostock Geschäftsführung: Erwin Pietz, Matthias Moeller Amtsgericht Rostock - HRB 7497 ________________________________ "Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie sicher, dass die Information in dieser Nachricht ausschließlich an die adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie gesendet worden sein, dann informieren Sie bitte umgehend den Absender und löschen Sie die Nachricht. Vielen Dank." "The information in this e-mail and any attachments is confidential. The information must only be held in areas that have controlled and limited access to the addressed persons. If this e-mail has been sent to you in error, please immediately notify the sender and delete the e-mail. Thanks." ________________________________ Von: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] Im Auftrag von James Flavell Gesendet: Donnerstag, 13. Mai 2010 10:24 An: development-axapta@yahoogroups.com Betreff: [development-axapta] AX4.0 how to know batch process is running Hi everyone, I am not sure if this has been asked in the group before but if yes please help direct me to the posting I want to setup some way to alert me if the batch process (or batch user login) has failed or not been started in AX4.0. Basically I have several companies and about 5 batch groups in each so that is 10 batch processes that need to be running. I just want a simple way to get an email notification if the batch process is not running Usually the problem is the batch user session is terminated for various reason such as hardware problem So I was thinking is there some SQL script I can make to check the batch user is logged in or somehow from outside AX query what batch groups or processes are currently running in AX? Thanks in advance for your help James [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]