Automic Workload Automation

 View Only
  • 1.  Automic Job to connect and run jobs in JDE

    Posted 5 days ago
    Hi Community,

    we have a need to extract the run parameters from database table and Pass those parameters to a JDE job to trigger a report.

    This completion will trigger an email to the user distribution list  indicating that the job(s) have been completed and also store the extract(s) in a designated folder.

    for this do be done - I have below questions. Appreciate if anyone can help me with this.

    1. What does it take to have an Automic job connect to JDE ?
    2. How can this Automic job trigger JDE OnDemand job ?

    Regards,
    Shravan Shetty


  • 2.  RE: Automic Job to connect and run jobs in JDE

    Broadcom Employee
    Posted 4 days ago
    Hi Shravan,

    please have a look at our Agent for JDE.
    https://downloads.automic.com/downloads/advanced_mode?selected_tab=id_search-result-files&lifecycle_entity_id=1409731986380&major_version_id=1650886234599%2C1642062623846%2C1638901556455%2C1542263593731%2C1542263593723&search=

    Regards, Markus


  • 3.  RE: Automic Job to connect and run jobs in JDE

    Posted 4 days ago
    Hi Markus,

    Thankyou for your response!

    I can understand we need a JDE agent and a connection to it. 
    I need to know how can I trigger job in JDE from Automic by passing parameters?

    Regards,
    Shravan Shetty


  • 4.  RE: Automic Job to connect and run jobs in JDE

    Posted 3 days ago

    Ok, I made some assumptions and don't dive into too much detail but....

    build a workflow that does the following (note: having generate at runtime is important to these jobs)

    first run a sql job to do your extract, the post processing can get the value out of your extract (prep_process_report) and push them to the parent workflow (pset)  If you need this extract in a folder you can use the write process to copy the report there.
    A jde agent jobs can inherit the parents variables. and you can used them in data selection or procesiing options overrides. In the post process Prep  process report again) to get the job number and push that to the parent and send and email. 
    A followup OS or File transfer job (depending on the OS of the enterprise server that ran the job)  can use the job number to pull the jde report PDF from its normal output location and move it to a designated folder.