BizTalk Server Administration - Biztalk Cleanu Jobs

Author

Biztalk Cleanu Jobs

MANDLA MKHWANAZI

2005-04-29, 7:59 am

When we installed biztalk 2004 in our server these jobs were created on the
SQL Server Scheduler (MessageBox_Message_Cleanup_BizTalkMsgBo
xDb and
MessageBox_Parts_Cleanup_BizTalkMsgBoxDb
). The problem is why are this jobs
scheduled to run every minute and sometimes failed on this error message

Arithmetic overflow error for data type smallint, value = 32777. [SQLSTATE
22003] (Error 220) The statement has been terminated. [SQLSTATE 01000]
(Error 3621). The step failed.

will there be a problem is we changes this schedules to run once a day? and
what impact will this have on the Biztalk Databases?