SQL Statement to retrieve Information from Activities Window
Article ID: 89105
Updated On:
Products
Issue/Introduction
Environment
Component:
Resolution
!NOTE: Please test in Test-Environment before running in Production Environment
Sql-Statement to retrieve Information from Activities Window:
In certain situations it is necessary to retrieve Information about recurring Jobs from the Activities Window.
For example a Production Down where a Login Into the System is not possible anymore and Jobs needs to be deleted from Activities Window.
You will need the info about the Jobs in the Activity window to reschedule them once the System is back up and running.
Before deleting Information from the Activities Window, it is necessary to find out what Jobs are currently in the Activities Window so they can be rescheduled again manually after the System is back up and running.
The following statement will retrieve all information that is necessary to restart tasks manually after they are deleted from the Activities Window.
Select EH_Client as Client,
EH_Name as Object_Name,
EH_Otype as Object_Type,
EH_AH_Idnr as Run_ID,
EH_ParentPrc as Parent_Runid,
AH_Timestamp1 as Activation_Time,
EH_StartTime as Start_Time,
AH_Timestamp4 as End_Time,
EH_LastOccur As Last_Occurence,
EH_NextCheck as Next_Occurence,
EH_Status as Status,
(select AH_NAME from AH where AH_IDNR = EH_ParentPrc) as Parent_Object_Name,
(select AH_Otype from AH where AH_IDNR = EH_ParentPrc) as Parent_Object_Type,
(select AH_Status from AH where AH_IDNR = EH_ParentPrc) as Parent_Object_Status
from EH
left outer join AH on AH_IDNR = EH_AH_IDNR
Order by EH_Client ,EH_Otype, AH_Timestamp4;
NOTE! All Time Information retrieved from database is in UTC time!
Feedback
