Hi,
I scanned my BizTalk Server using Best Practices Analyzer and found
that I need to schedule and enable the 'DTA Purge and Archive
(BizTalkDTADb)' job. I configured the
dtasp_BackupAndPurgeTrackingDatabase proc passing 0, 1, 2 as first 3
input parameters.
Now I see warning messages every minute(since the default job schedule
is to execute every min.) in my Event viewer saying:
SQL Server Scheduled Job 'DTA Purge and Archive (BizTalkDTADb)' -
Status: Failed - Invoked on: 2006-12-08 00:31:00 - Message: The job
failed. The Job was invoked by Schedule 40 (Archive and Purge
Schedule). The last step to run was step 1 (Archive and Purge).
How do I get more details/information on reasons behind the job failure
and how to resolve it.
Appreciate your responses.
Thanks,
Kiran Pabba
