.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;
bam_FRRView_ViewFRRMessagesIn_DelAlertHistJob
bam_FRRView_ViewFRRMessagesOut_DelAlertHistJob
bam_RepairView_ViewMessage_DelAlertHistJob

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!

0 Comments:

Post a Comment

<< Home