Education & Training
Services & Support
CA Automic Community
CA Automic Workload Automation
to create and rate content, and to follow, bookmark, and share content with other members.
Is there a way to use a script to get a total number of objects executed during a specific period?
Discussion created by
on Aug 25, 2015
on Sep 1, 2015 by Jennifer_Jinhong_34
Show 0 Likes
I would like to schedule a script to process on the first day of the month that can provide a total number of objects executed within the previous month. Does anyone know how this could be done?
This content has been marked as final.
Show 2 comments
(Required, will not be published)
Aug 26, 2015 5:31 PM
I don't know any UC4 script that can accomplish this but with a simple SQLI variable you can get this information. Just create a SQLI VARA object and insert a query like the one below :
select count(*) from ah where AH_OType in ('JOBS','JOBF','JOBP','SCRI','EVNT','CALL','JOBG','JSCH') and trunc(AH_TimeStamp1)=trunc(sysdate -30)
Just make a script run a get_var on this variable on the first day of month and that's all.
It's just an example considering some executable objects.
Other option is to create a DB job if you need a more complex set of clauses.
Show 1 Like
Sep 1, 2015 4:53 PM
, the DB.Reporting tool can generate the report for you.
Here's a link to a post with the Whitepaper and discussions about it:
Technical WhitePaper - Creating Reports using the UC4.DB Reporting Tool Utility
Show 0 Likes
Retrieving data ...
TMA-601 - Timesheet could not be saved
session multi-noeuds (meme société)
Workflow not showed as available in project if a template is selected
Regarding - CA PPM Process
JDBC Virtualization - SQL Server 2008