BizTalk Server General - SQL Agent "TrackedMessages_Copy

Author

SQL Agent "TrackedMessages_Copy_BizTalkMsgBoxDb" fails

Hakan

2005-04-26, 2:48 am

Hi,

We have BizTalk Server 2004 SP1 & SQL Server 2000 on the same box. The load
is minimal rigth now (about 20 messages per day). I noticed that when BizTalk
reveices a message, usually the SQL agent job
"TrackedMessages_Copy_BizTalkMsgBoxDb" fails. It is reporting the following
problem:

SQL Server Scheduled Job 'TrackedMessages_Copy_BizTalkMsgBoxDb'
(0x00950D7219632942988ACDAFD37B3481) - Status: Failed - Invoked on:
2005-04-26 06:35:00 - Message: The job failed. The Job was invoked by
Schedule 65 (Schedule). The last step to run was step 1 (Purge).

Do you have any idea about how to fix it? Our agent is running once a minute
for the time being? Is it too frequent for a low volume of traffic?

Hakan Yarar
hakan_yarar@hotmail.com