Feature Request - Max Days to Keep Execution Log History

  • Posts: 23
  • Thank you received: 3

Feature Request - Max Days to Keep Execution Log History was created by IMS

We'd love to have a config option to specify the maximum number of days to keep the execution log history and logs on disk.

It would be nice to be able to set it for whatever number of days you wanted to keep old logs and have the option to say whether or not to also kill the txt logs on disk associated with those log entries.

In a perfect world, this would be a global default and you would also have the ability to set it at the scheduler level so you could have different values for different jobs.

For example, you may only want to keep logs for some jobs for 7 days and others for 90 days for auditing purposes.

Having just one global setting to start with would be a great first step.

We just went and cleared out our full execution log history as it had stacked up around 170,000 log files on the disk over the past year or so and was consuming 13.3 GB of drive space.

Obviously, this is not a must have feature but would be quite nice to have to make things more set it and forget it.
The following user(s) said Thank You: admin, bruce.gibbins
3 years 1 month ago #19109

Please Log in or Create an account to join the conversation.

  • Posts: 8470
  • Karma: 33
  • Thank you received: 569

Replied by admin on topic Feature Request - Max Days to Keep Execution Log History

That sounds like a good idea, we will have a look at it for you
Mike
ETL Architect
3 years 1 month ago #19112

Please Log in or Create an account to join the conversation.

  • Posts: 8470
  • Karma: 33
  • Thank you received: 569

Replied by admin on topic Feature Request - Max Days to Keep Execution Log History

Hi

We created a separate action for it. It is called "Clear log"
I think it is the most convenient way of implementing this functionality.
You can just schedule it and forget about it.
I hope you will find it useful



www.etl-tools.com/wiki/aetle/packages/clear_log_action
Mike
ETL Architect
2 years 11 months ago #19276
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 261
  • Karma: 1
  • Thank you received: 18

Replied by DeanCovey on topic Feature Request - Max Days to Keep Execution Log History

This seems to work.

The following user(s) said Thank You: admin
2 years 11 months ago #19284
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 8470
  • Karma: 33
  • Thank you received: 569

Replied by admin on topic Feature Request - Max Days to Keep Execution Log History

It does but it will not delete records from QUEUE_HISTORY and QUEUE_ACTIONS_HISTORY tables.
Clear log action does delete them.
Mike
ETL Architect
The following user(s) said Thank You: DeanCovey
2 years 11 months ago #19288

Please Log in or Create an account to join the conversation.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies