Hi Scott,
Select complete_time, status, user_log from dbo.status_log order by Complete_time desc
There's not that much logged in DS 6.9 and there's really only 4 tables that I know of that are to do with it, 2 of them are archive ones. Status_log and history tables contain all the information recorded relating to task executions, they differ slightly, you may wish to combine columns on both tables. It is probably suitable information for auditing as there are usernames mentioned against task executions with task details. Please note, keeping records of the details of the tasks is more tricky since these can be overwritten.
A stored procedure runs on a schedule that is not publically documented. The SP’s are ins_archive_history and ins_archive_status_log. These SP’s move the data to the archive’s of each table around every 24 hours. If you make a change to the Options, you can restart the services to trigger them manually.
The default setting for governing the truncation of data from these tables is in Tools >Options >Global tab à “Delete history entries older than X days” and is ‘undefined’ on a fresh product install.
So as long as you haven’t defined that setting you will have unlimited history in Status_log_archive and History_archive.
HTH, take care buddy!
Mike