MSMQ Monitor

The MSMQ Monitor checks Message Queue (MSMQ) for new messages.

• Multiple Queues can be monitored
• Automatically performs user-defined tasks and actions.

Creating New Monitor

• To create a new Monitor select the “Event Monitors” tab and click New
• Dialog box will appear
• Fill in the Description edit box with the name of the Monitor you are about to create
• Select Message (MSMQ) as an event to monitor
• Change computer name if necessary
• Select MSMQ connection to monitor from the drop-down box
• Switch to execute tab
• Select object to execute
• Change computer name if necessary
• Change application platform if necessary
• Click OK to finish the creation of the Monitor

Installing MSMQ Monitor

MSMQ Monitor service is automatically installed during setup but not configured.

It can be also installed using the command line

To install the MSMQ Monitor as a service run the following command:

aetlmsmqmonitor.exe /INSTALL

for Advanced ETL Processor

vimpmsmqmonitor.exe /INSTALL

for Visual Importer ETL

If the Monitor is already installed it must be uninstalled first

To uninstall the Monitor as a Windows service you must run the Monitor with the /UNINSTALL switch as follows

aetlmsmqmonitor.exe /UNINSTALL

for Advanced ETL Processor

vimpmsmqmonitor.exe /UNINSTALL

for Visual Importer ETL

The commands above must be executed as administrator (elevated).

Configuring MSMQ Monitor service

It is recommended to run MSMQ Monitor using the same user used to design Packages/Transformations/SQL scripts.

• Open windows services
• Find MSMQ Monitor in the list
• Double click on it
• Dialog box will appear
• Set startup time to automatic
• Change user name
• Start the service

Important Notes

• MSMQ Monitor is only available with Enterprise Version.
• MSMQ Monitor assumes that Message Queue should be always empty.
• When it is not empty it records the arrival time of the first message.
• When the arrival time of the first message changes it fires the event.
• (It happens when some software removes all messages and a new message arrives)

Checking Monitor Status

• Make sure that the monitor service is up and running
• Make sure that the monitor service is using the appropriate user name and user
• Make sure that the monitor is enabled on the maintenance tab
• Make sure that the monitor is enabled on the Event monitors tab
• Make sure that the execution agent is configured properly

Monitor is enabled on Maintenance tab

Monitor is enabled on Event Monitors tab

Action was submitted by MSMQ Monitor

MSMQ Monitor Variables

<Monitor ID>