Integration Log Configuration Change

[timroop]

We have historically logged integration results to the IM database itself. I am changing that as the file is getting large and the purge process is cumbersum.

I would like to set the Ingegration setup to log to file for each of about 600 integrations at once.

Anybody have an Idea on where in the IM.MDB to set this? I've poked around but haven't had much luck.

Thanks.

Tim

Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva

 

[TallOne]

I haven't done it yet, but I plan on using something like the following in a vbscript after integration. Unless I've missed a table, these should delete all log records older than 30 days. Instead of 30 days, I'll probably use 90 or even more. It may be slow on the first run, but afterwards, your maintenance should be quick and easy.

Delete from logdocuments where logid <= (select Top 1 LogID from logactivity where activitytime < getdate() - 30 order by activitytime desc)
Delete from logactivity where activitytime < getdate() - 30
Delete from logdocumentactivity where activitytime < getdate() - 30

TallOne