.comment-link {margin-left:.6em;}

Ben Cops

Monday, April 14, 2008

BizTalk 2006 SQL jobs

This link: Database Structure and Jobs contains a list of all SQL jobs used by BTS2006 and a description.

You might have another few jobs in there;

These are from the SWIFT accelerator - FRR stands for FIN Response Reconciliation.

I like this part best:
In the BizTalk Management (BizTalkMgmtDb) database, there's a stored procedure named dbo.adm_cleanupmgmtdb. DO NOT RUN THIS STORED PROCEDURE! If you do run this stored procedure, all the entries in the database will be deleted.

Brilliant! Don't install the procedure then!


Post a Comment

<< Home