Automic Workload Automation

Expand all | Collapse all

active workflows via email

Jump to Best Answer
  • 1.  active workflows via email

    Posted 18 days ago
    Hi,

    i will send daily at 6.15 am the following details per email:

    -active workflows between 0.00am - 06.00 am
    -startime of the workflow



    result:

    i only get the start date of the workflow. :/
    How can i get the starttime of the workflow (oracle database)?



    Thanks in advance.


    Best regards
    Salih



  • 2.  RE: active workflows via email

    Posted 12 days ago
    Hi

    thats a setting in your local ORA client somewhere on NLS section.
    Sry I am no oracle expert by far so no idea which one it is  exactly :-(

    I have the same behavior using an SQLI VARA (time included) and Oracle SQL developer (date only)

    hope this helps a bit.

    cheers, Wolfgang

    ------------------------------
    Support Info:
    if you are using one of the latest version of UC4 / AWA / One Automation please get in contact with Support to open a ticket.
    Otherwise update/upgrade your system and check if the problem still exists.
    ------------------------------



  • 3.  RE: active workflows via email

    Posted 12 days ago
    Edited by Pete Wirfs 12 days ago
    I think EJPP_StartTime needs to be wrapped with a function like so;

    to_char(EJPP_StartTime,'mm-dd-yyyy hh24.mi.SS') as StartTime

    And note it is stored in GMT, so you may also want to adjust it for that too.  (I know how to do this in SQLServer, but I don't know how to do this in Oracle.)

    EDIT:
    The Oracle function that can convert timestamps to different time zones is NEW_TIME()

    ------------------------------
    Pete
    ------------------------------



  • 4.  RE: active workflows via email
    Best Answer

    Posted 12 days ago
    ​Or try this. This is how I get usable time stamps from Automic tables on Oracle:

    ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-RR HH24:MI:SS';

    Hth,


    ------------------------------
    These contain very good advise on asking questions and describing supposed bugs (no, you do not need to go to StackExchange for Automic questions, but yes, the parts on asking detailed, useful questions ARE usually relevant):

    http://www.catb.org/~esr/faqs/smart-questions.html

    https://www.chiark.greenend.org.uk/~sgtatham/bugs.html

    I will not respond to PM asking for help unless there's an actual reason to keep the discussion off of the public forums.
    ------------------------------



  • 5.  RE: active workflows via email

    Posted 11 days ago
    It works! Thank you :)