Re: Biztalk 2006 with SQL-Express - Gert

Hi Gert,

Sorry for the late reply, I forgot to use the reply notification for this :P

This is the link for the list of BizTalk 2006 Maintenance Jobs
http://msdn.microsoft.com/en-us/library/aa561960.aspx

Below I provide the details of the execution script with the interval.

Important Notes :
1. For DTA Purge and Archive (BizTalkDTADb) job, I use purge without backup
since I'm using this for development purpose, for details please refer to
http://msdn.microsoft.com/en-us/library/aa560754.aspx
2. If you want to use this, please test it in your development / testing
environment first. Do not use this directly in production without having any
test first. It is best if you try to download an SQL server (not express)
evaluation edition just to verify whether the job details are valid.
3. I found that the SQLScheduler often hangs (status executing) without any
reasons, so you also need to find out more if you're going to use it for
production purpose.

Hope this helps ;)

BizTalk Database Maintenance Jobs
-----------------------------------------------
Name : CleanupBTFExpiredEntriesJob_BizTalkMgmtDb
Interval : 1 Day / Recurring
Script :
Use BizTalkMgmtDb
exec btf_PurgeExpiredMessages
-----------------------------------------------
Name : DTA Purge and Archive (BizTalkDTADb)
Interval : 1 Minute / Recurring
Script :
Use BizTalkDTADb
declare @dtLastBackup datetime set @dtLastBackup = GetUTCDate()
exec dtasp_PurgeTrackingDatabase 1, 0, 1, @dtLastBackup
-----------------------------------------------
Name : MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_CleanupDeadProcesses
-----------------------------------------------
Name : MessageBox_Message_Cleanup_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_PurgeMessages
-----------------------------------------------
Name : MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_ManageMessageRefCountLog
-----------------------------------------------
Name : MessageBox_Parts_Cleanup_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_PurgeParts
-----------------------------------------------
Name : MessageBox_UpdateStats_BizTalkMsgBoxDb
Interval : 5 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
set deadlock_priority low
exec sp_updatestats
-----------------------------------------------
Name : Operations_OperateOnInstances_OnMaster_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec ops_OperateOnInstancesOnMasterMsgBox '.\SQLEXPRESS', 'BizTalkMsgBoxDb'
-----------------------------------------------
Name : PurgeSubscriptionsJob_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_PurgeSubscriptions
-----------------------------------------------
Name : Rules_Database_Cleanup_BizTalkRuleEngineDb
Interval : 1 Hour / Recurring
Script :
Use BizTalkRuleEngineDb
exec re_cleanup_database
-----------------------------------------------
Name : TrackedMessages_Copy_BizTalkMsgBoxDb
Interval : 1 Minute / Recurring
Script :
Use BizTalkMsgBoxDb
exec bts_CopyTrackedMessagesToDTA '.\SQLEXPRESS', 'BizTalkDTADb'
-----------------------------------------------

"Gert Lynge" wrote:

Hi Bembeng Arifin

Yes, BizTalk Server 2006 can be installed with SQL Express 2005 editions,
I have been using this for several months now.
Regarding to the job agent, it is not available in SQL Express 2005, so
yes, I also would not recommend that for production usage, however, if you
need that for development or testing purpose, you can use SQLScheduler
from LazyCoding.com (http://www.lazycoding.com/products.aspx).
http://bembengarifin-tech.blogspot.com/2008/05/biztalk-server-2006-development-with.html

Thanks... Our Biztalk messages are very low volume and I'm keeping a eye on
the DB size but have not been concerned with the growth yet. So I guess we
are staying on Express until we get a problem or are reconfiguring for other
reasons.
To setup the maintenaince jobs I need a list of jobs with scheduling
information (when and how often) and what exactly they do (i.e. which stored
procedure they call etc.).

Do you know if these information is available online?
Would you maybe be kind enough to send me some screendumps with the
information?

Best regards
Gert Lynge


.

Relevant Pages

  • Re: Netcat question
    ... Also, I apologize since I think you might have provided this already, but can we see the virtual device script? ... Maybe a quick & dirty hack fix is to have the virtual device script always append something unobtrusive to the collected print data for no other reason than to garuntee that the print jobs are always at least a few bytes. ... It uses a cheap-o single port print server that snaps onto the centronics plug just like that netgear ps101. ...
    (comp.unix.sco.misc)
  • Re: Netcat question
    ... If you write the virtual device script to simply throw out all output from ... than to garuntee that the print jobs are always at least a few bytes. ... It uses a cheap-o single port print server that snaps onto the centronics ...
    (comp.unix.sco.misc)
  • Re: Plattform independent queuing of computations
    ... The idea ist to put the computation jobs into a database which is read ... The external task uses the database as a queue ... website the socket will be closed when the script is finished and the ... And if the rest of the code doesn't have problems with loops, you can set the execution time longer and memory larger. ...
    (comp.lang.php)
  • Re: prevent users from running system statistic tools
    ... > routines to see how their jobs were running. ... > I considered a script that would issue a talk command to the user. ... Have your manager have a chat with their ...
    (comp.unix.solaris)
  • RE: Cant clear Routing Failure Report
    ... getting database locks when the clean up jobs ran due to 2 un-correlated EDI ... > Currently we are expreciencing an issue with our BizTalk database whereby we ...
    (microsoft.public.biztalk.general)