Monitor Log clean up when Job is running

dataservices job design
1

Hi All,

I have a DI job that runs in While loops. The while loop will run for 200+ times. Because of this, the monitor log file becomes huge and Admin console takes more time to load or sometimes gives read timed out error.

Whatever the situation, I don’t want those initial loops of the monitor logs being displayed or being occupied in the monitor log file. I am less bothered about that.

Is there anyway i can simply delete the monitor log file’s first 50 lines or something like that, while the job is running? Or do i need to write unix(which I am not familiar) script to delete such kind?

Thanks in Advance.

rookie86 :india: (BOB member since 2009-09-11)

2

Without writing scripts to delete the file somehow your best bet is to either set the monitor sample rate to 64000 or to 0 when you kick off the job. Depending if you actually need the numbers it produces in your 200+ runs.

I’m guessing you’re using the default 1000 row sample rate which is too small.

ScoobyDoo :uk: (BOB member since 2007-05-10)

3

Thanks for your reply.
I currently have 64000 records as sample rate. Better I will make it as 0 ,try out and update this post.

rookie86 :india: (BOB member since 2009-09-11)