Extracting job definitions from Automic

[SrinivasanNagaraj630469]

Hi,
I'm new to Automic. I want to know if there is a way to extract the job schedule with details such as the pre and post dependencies, script name, the thread information, calendar (frequency), etc... 
If yes, what formats are being supported? The idea is to know after configuring the jobs in Automic, if there's an easy way to extract all the job definitions so we can check and validate the details?

[Carsten Schmitz]

Hi.

The following comes to mind:

• XML export of objects
  
  you could possibly extract various attributes from the XML exports. Caveats: manual labour (unless you somehow automate the export), and the format has recently been downgraded to an "officially not for public consumption" status. The format may change at any time. Probably not suitable for more than a few select objects.
  
  
• custom SQL queries
  
  You can read the Automic database and construct custom SQL queries to get the information. Caveats: mostly undocumented tables and dependencies, some dependencies are rather arcane (such as information contained in Oracle binary BLOBs). May take serious effort to construct a solution that covers anything beyond basic object properties.
  
  
• Analytics
  
  You may want to look into what Anlytics can provide. I have no experience with it though, no idea if it provides what you need, but it's free from Automic with an AE license.
  
  
• Third Party Tools, some officially sanctioned or sold by Automic
  
  This may be your best bet at external object documentation and analysis. The two major players appear to beOmniView andXinfo. At least OmniView positions itself as a solution to extract and document the properties you ask for. XInfo may do the same. Caveat: Extra costs, mostly.
  
  

Disclaimer: I am not associated with any third party tools manufacturer/supplier for Automic (or Automic, for that matter).

Hope this helps.

[SrinivasanNagaraj630469]

Hi Carsten,

Thank you for the response.
I was thinking if it allows exporting in csv in addition to XML (we had this option in BMC Control-M). But curious to know if Automic also offers that feature?

[Carsten Schmitz]

Hi SrinivasanNagaraj630469,

No, there is, to my knowledge, no csv export. There's only XML (and, as mentioned, not advertised as a stable user-facing format), and one more format: The proprietary "Transport Case format." While the later has been partly analyzed by Michael_Lowry, it's not useful for generating external object documentation, either.

Best,
Carsten

[SrinivasanNagaraj630469]

Thank you very much Carsten_Schmitz_7883. 

[Carsten Schmitz]

You're welcome, happy to help :)