visual enterprise

Two topics today
1. I have a process set on infinite loop, using the pause object, to bring data across systems. This works great.
My concern is the log that is being generated. Normally a log is started and completed upon execution, while this one continues to grow.
Is there someway to control or just prevent the log in this type of instance?
Can the log out grow the resources>

the job starts at 4am and ends at 10pm
getting log entries every 1 second

2. maybe a new object.
you have the date object, how about a time object?
with choice of between start time and end time or just end time?
I am using sql code within a data object to test end time, but an object might be cool

We will have a look at it for you

Hi Alan.

Not sure if you are aware but we do have an object dedicated to clearing logs.

www.etl-tools.com/wiki/aetle/packages/clear_log_action?s[]=clear&s[]=log

Please let me know if it is helpful or not

I will take a look at it
I manually delete every other week on our production machine so we review if necessary
and have an automated bat file process on a different machine

My issues is if I loop it via etl packages, its takes 3-5 seconds, which is to long, but the log closes
if i turn it on, with start and end times, say for 12 hours straight, the timing is perfect, but the log is huge and can only be purged when complete.

I also believe the huge log causes overall slowness in the etl

I am confused when you say huge log are you talking about records in the database or the actual log file?

Please post a screeshot

let me set it up and i'll send you the info tomorrow