VERIFIED SOLUTION i
X

How to track a plan process in Sagent Dataflow

UPDATED: March 21, 2018


There is no direct interface to track plan execution details. Use Sagent logs and Sagent Admin utility to see the state of the plan under execution.

1. Sagent Logs:
Enable dc status logs to track the plan execution along with checking the status in Sagent Admin. To enable DFS Status Logging, open the Registry Settings, navigate to path: 'HKEY_LOCAL_MACHINE\SOFTWARE\Sagent\DataMart\DC' and create following keys:

STRING Type entries:
  • 'StatusFile' Value as 'C:\DFS.log' (mention the path of the log file)
DWORD Type entries:
  • 'IncludeStepStatus' value as 1
  • 'StatusInterval' Time in seconds (e.g. 10 seconds)
  • 'ExecStatus' value as 1
  • 'ResourceStatus' value as 1
  • 'DatasSourceStatus' value as 1
  • 'ResultsStatus' value as 1
PS: DC Status logs can grow exponentially, so disable them after fetching the required information.

2. Sagent Admin:
Enable the plan execution status by checking the 'Track User Session' checkbox in Sagent Admin. This creates entry in the 'sarp_track_plan' table for each execution of Sagent plan.

User-added image

Environment Details

Product Feature: DataFlow Server

 

Downloads

  • No Downloads