Ravindar, Biztalk Developer and Administrator

Just another BizTalk blog

Directly querying the BizTalk database for suspended messages

SELECT
nvcName as ApplicationName,
DATEADD(hh,-6,dtSuspendTimeStamp) as DateSuspended, — Subtract the appropriate hours for your timezone
nvcAdapter as Adapter,
nvcURI as URI,
nvcErrorDescription as ErrorDescription
FROM InstancesSuspended
LEFT OUTER JOIN [Services]
on InstancesSuspended.uidServiceID = [Services].uidServiceID
LEFT OUTER JOIN Modules
on Modules.nModuleID = [Services].nModuleID
WHERE DtCreated between DATEADD(dd,-7,GETUTCDATE()) and GETUTCDATE()
and nErrorCategory=0
ORDER BY dtCreated desc

article source
http://geekswithblogs.net/bosuch/archive/2010/11/29/directly-querying-the-biztalk-database-for-suspended-messages.aspx

Advertisements

June 12, 2011 - Posted by | Biztalk Server

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: