Help with SQL query on Jobs and Job Plans

[PuranBaru]

I have some questions on the retention of jobs in Automic.  There is no "active/inactive" flag for the Job Plans. They either exist or are deleted.  Batch jobs are added to job plans so that they can be scheduled to run.  There are jobs that are no longer needed, but no active cleanup activities. I would like to find all the jobs that can be deleted that are no longer running/needed.

 

I would like to get a SQL statement that returns Automic data that might help with cleanup:

 

1. The most recent run date for all jobs that are in Job Plans
2. The scheduled run frequency for all job plans

Thanks for your assistance.

------------------------------
Puran B
------------------------------

[Heena Tabassum]

Hi puranbaru82455801, 

I see that your query is related to CA Automic Product, please post your query on product page for the visibility of the engineers. 

Here is the link: https://community.broadcom.com/enterprisesoftware/communities/communityhomeblogs?CommunityKey=2e1b01c9-f310-4635-829f-aead2f6587c4

Regards, 
Heena

------------------------------
Regards, 
Heena Tabassum
Customer Care Community Admin
Broadcom
------------------------------