As noted earlier in this document, actions from the Test Run tool are logged in text files. However, when a schedule executes a workflow, or using the “Run now” option, step information is logged to the SQL database used by Bizweaver.

Transaction logging data is found in the table VGO_SYNC_PROC_LOG. An entry is made for each workflow step that is executed. In addition to workflow and step information, any errors reported from Bizweaver steps is recorded. This provides a mechanism for reporting execution issues.

The log table can be accessed via SQL Management Studio or from a report in Versago. Following is a SQL Select statement to access this information.

SELECT
 
t0.JobID, t0.TaskID, t1.TaskName, t0.StepType, t0.Step, t0.[TIME], t0.Message
 
FROM vgo_sync_proc_log t0
 
INNER JOIN VGO_SYNC_TASKS t1 ON t0.TaskID = t1.TaskID

The log information for a specific workflow can also be accessed using the “View Job Log” function described in the “Icon Bar” section of this document.