How to send email notification with list of job plans current status?

[Pankaj Dhole]

Dear All. 

Currently I have list of job plans 'JOBP' running in Automic v12 all day but at 1 PM I have to send email with few job plans current status in below table format.
JOBP Name /Activate date/Current Status/Runtime. 

I am using SEQ_SQL variable and using below query. 

select
oh.oh_name,
ah.AH_TimeStamp1 as activation_time,
ah.AH_TimeStamp2 as start_time,
ah.AH_TimeStamp4 as end_time,
((ah.AH_TimeStamp4 - ah.AH_TimeStamp2)/24) as runtime_hour
from
uc4.oh oh, uc4.ah ah
where
oh.oh_idnr = oh.oh_idnr
and ah.ah_timestamp1 = SYSDATE
---------------------

The question is how shall I call this query into call object? using send email fuction in script?

[Frank Muffke]

Hi

basically you can use script function PREP_PROCESS_VAR in combination with PUT_ATT_APPEND CALL_TEXT in a CALL object.

I personally doubt that this SQL will return any useful value as there is no Name/runid/client/object type etc specified and oh.oh_idnr = oh.oh_idnr is not latest trend in designing SQL queries :-)

cheers, Wolfgang

------------------------------
Support Info:
if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
Otherwise update/upgrade your system and check if the problem still exists.
------------------------------