We need some urgent help in configuring Message Queue Polling from the Object Spawner.
We are using the Websphere MQ. Scenario : When a message arrives in a WebSphere MQ Queue a SAS ETL Job needs to be triggered.
This SAS ETL Job will read the message and process it.
Above mentioned scenario is mentioned at "http://support.sas.com/rnd/itech/doc9/dev_guide/messageq/sasqsid.html"
But it is not clear how to do it.
Can any one suggest how to accomplish such a scenario, or give an alternative suggestion.
I have gone through this link also. I tried out the configuration, but the main issue is how to configure which job to trigger when a message arrives in a queue. I am using Windows OS for SAS server as well as for MQ server.
Using the method given in the link when I send a message to the transmission queue, The trigger manager gives an error that the TMC command is not recognized. I used runmqtmc -m QMSAS -q QSAS to start the trigger monitor (I am using MQ Client that's why i am using runmqtmc and not runmqtrm). The trigger monitor stars without any problem but when i send a message the trigger message is printed on command prompt : "TMC 2QSAS PROCESSOBJECTSAS QMSAS "
TMC is not recognized as an internal or external command, operable program or a batch file.
The issue remains (for any approach) where to configure the name of the job which is to be triggered.
Also i would like to ask does the triggering of SAS ETL Job from MQ work in Enterprise edition of SAS Server only. I am working on Data Integration SAS server (Which is not an Enterprise Edition).