Suspend Q montoring

[BizTalkUser]

All of you BizTalk users outthere, how do you monitor your
suspended Q regurlarly? I don't want to buy MOM or
Application center. I mean I can't be at front of my
BizTalk server 24 X 7. Any thoughts are welcome.

[Pieter van der Merwe]

BizTalk Utilities has a feature that will mail you with the suspended doc as
well as the event log entry.

It can be found at www.topxml.com

"BizTalkUser" <BizTa...@yahoo.com> wrote in message
news:04c101c357a7$ce376e40$a301...@phx.gbl...

[Roland Osterode]

you can monitor the cs_suspendedQ table with a sql-job

1. create a second table for correlation in the InterchangeSQ Database, for
example table init_checkme
2. configure a sql-job whick execute this t-sql every X minute, show the
script below
3. have a look at the end of the the script: if an entry in the
cs_suspendedQ table has occured i call a batch file which will send me a
mail via blat. for more information about blat smpt mailer search the
internet, it is very easy to use.

here is the script: it wil recognize entries that will be younger than ten
minutes, (so you must set the timer for the jobexecuting earlier than every
10 minutes)

DECLARE @tenMinutesAgo datetime

SELECT
@tenMinutesAgo = DATEADD ( minute , -10, getdate() )

-- clear old events from 'Init_Checkme'
delete from Init_Checkme
WHERE cs_suspended_nID NOT IN
(SELECT nid from cs_SuspendedQ )

if exists (
SELECT dtsubmit
FROM cs_SuspendedQ
WHERE dtsubmit < @tenMinutesAgo
AND NID NOT IN (SELECT cs_suspended_nID FROM Init_Checkme)
) begin
INSERT INTO Init_Checkme(cs_suspended_nID)
select nid from cs_SuspendedQ
WHERE dtsubmit < @tenMinutesAgo
AND NID NOT IN (SELECT cs_suspended_nID FROM Init_Checkme)
--PRINT 'ALARM'

exec master..xp_cmdshell 'd:\tools\scripts\SuspendQueueEvent.bat'

end

"BizTalkUser" <BizTa...@yahoo.com> schrieb im Newsbeitrag
news:04c101c357a7$ce376e40$a301...@phx.gbl...