Automic Workload Automation

 View Only
  • 1.  SQL Query Job To .TXT File

    Posted Jun 24, 2020 06:13 PM
    I created a Query Job but I am having trouble exporting the job to a file. How can this be done? If there are multiple ways I'd appreciate hearing each of them. Does the output have to be transferred back to the Automation Engine? I'd like to keep it all agent based but knowing if there is a non-agent solution would be useful for the future.


  • 2.  RE: SQL Query Job To .TXT File

    Posted Jun 24, 2020 10:25 PM
    Hi Dillon,

    I am not clear on this requirement but just have a look on following if these are relevant ?  

    Are you trying to export UC4 job to a file ? ( it will be xml )  - https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Script/Reference/EXPORT.htm?Highlight=EXPORT

    Are you trying to use the SQL job's output file ? 
    - Enable the file option to retain the output in directory. 
    - use RUNNR2ALPHA in post process of the job to determine the output file name. 
    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Script/Reference/RUNNR2ALPHA.htm?Highlight=ALPHA

    ------------------------------
    Regards,
    Prosenjit
    ------------------------------



  • 3.  RE: SQL Query Job To .TXT File
    Best Answer

    Posted Jun 25, 2020 11:09 AM
    I have used the write_process() function to write txt or csv files from uc4;

    https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Script/Reference/WRITE_PROCESS.htm%3FTocPath%3DReference%7CAutomation%2520Engine%2520Script%2520Reference%7CScript%2520Elements%2520Ordered%2520by%2520Purpose%7CData%2520Sequences%7C_____19

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