SQL Statement to retrieve Information from Activities Window

Document ID : KB000089105
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
SQL Statement to retrieve Information from Activities Window
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!