Reports based on schedule (JSCH) objects

[Mylene Chalut]

Good day,

I am looking at a way to produce daily reports on jobs that have been scheduled.  We were using DollasUniverse not too long ago, and the Report Center was very user friendly and useful.  In One Automation, I don't even know where to start from.  Is there something equivalent, where we can produce those reports and send them to our clients by email ?  Is there maybe a video on the Youtube channel that shows how to do that ?

Thanks in advance for your help :-)

Mylene 

------------------------------
Programmer-analyst
Statistics Canada
------------------------------

[B Bharath Kumar Reddy]

Hi Mylene, 

I hope you already found solution for your problem.

You can use analytics to create the report and share the link (as external link) to the users so that they can directly view the data without having to login to Automic.

The other way would be to pull the executions from DB, store them in a VARA and convert it into a table using HTML under CALL Object and send it to the required recipients.

------------------------------
Bharath B.
------------------------------

[Mylene Chalut]

​Hello @B Bharath Kumar Reddy,

I did some reports with the Analytics tool. However, I need more information than what the tool is giving me. So yes, the answer is to query the database. Can you give me a hint in which table I would find the execution information ?
​

------------------------------
Programmer-analyst
Statistics Canada
------------------------------

[Mylene Chalut]

I found the solution:

select ah_Name

     , ah_otype

     , ah_status

     , ah_RetCode

     , ah_InfoText

     , ah_timestamp2 as StartTime

     , ah_timestamp4 as EndTime

     , ah_RunTime

from ah

where ah_client = 100

and ah_otype in ('JOBS','JOBP','EVNT','JSCH')

and ah_timestamp2 >= '2020-08-06 00:00:00'

and ah_timestamp4 <= '2020-08-07 00:00:00'

order by ah_timestamp2 desc

------------------------------
Programmer-analyst
Statistics Canada
------------------------------

[Pete Wirfs]

We do our daily "what has been run" reports via this reporting tool, but your query works too;
https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Utilities/admin_AEDBReportingTool_About.htm

This reporting tool has two output options; HTML and CSV.

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Mylene Chalut]

@Pete Wirfs,

I don't think I have that tool installed.  And my query is giving me all I need in the VARA.SQLI.  However, I can't get the information when I select that VARA in the VARA to Chart of the Analystics tool.  I guess I am missing a step ?  Can you please direct me to the proper documentation to have this working ?

Mylene​

------------------------------
Programmer-analyst
Statistics Canada
------------------------------

[Mylene Chalut]

I found it :-)

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Analytics/ANOP_User/Use_Cases/VARAtoChart_SQLi_Dynamic/VARAtoCHART_SQLi.htm?Highlight=vara.sqli%20to%20chart

------------------------------
Programmer-analyst
Statistics Canada
------------------------------