Execution log
In many projects it has proven useful to have detailed logs for the execution of procedures or processes. DataHandwerk offers the possibility of a formal logging into the table logs.ExecutionLog - U.
The table appears somewhat bloated at first glance with its many columns. The additional formal and optional information enables better evaluations. For example, activity diagrams can be created.
usp generator can be used to create procedures that can log the execution of the procedure, and the procedure steps in the log.
There are no updates in the logs.ExecutionLog - U table, only inserts.
generate PlantUML diagrams
The following PlantUML diagram can be generated using logs.ftv_ExecutionLog_puml_sequence_start_stop_per_execution - IF
The following detailed sequence diagram is created using
Select
id
, puml_Sequence
, execution_instance_guid
, parent_execution_log_id
, proc_schema_name
, proc_name
, step_id
, step_name
, created_dt
, source_object
, target_object
, inserted
, updated
, deleted
From
logs.ExecutionLog_gross
Where
id
Between 33386 And 33404
Order By
id;
use logging in your own dwh database
To use logging in your own dwh database, the logs
schema and its objects must be created there. This is especially useful if the usp generator is also to be used to populate the log.