1 Reply Latest reply: Sep 25, 2013 10:15 AM by sb92075 RSS

    Trigger workflow mails every wednesday

    user1165268

      Hi,

      I need to setup a workflow to send automated emails to Users in my Oracle CRM On Demand application that sends mail every Wednesday.

       

      I tried DAYOFWEEK() function used in reports but this function was not accepted in expression builder. I tried a workaround which required finding Mod of Julianday() but even Mod function wasn't accepted.

      Can anyone please suggest a workaround for this ?

       

      Thanks in advance!

        • 1. Re: Trigger workflow mails every wednesday
          sb92075

          user1165268 wrote:

           

          Hi,

          I need to setup an email trigger that sends mail every Wednesday.

           

          I tried DAYOFWEEK() function used in reports but this function was not accepted in expression builder. I tried a workaround which required finding Mod of Julianday() but even Mod function wasn't accepted.

          Can anyone please suggest a workaround for this ?

           

          Thanks in advance!

           

          You use bad choice of words.

          TRIGGER is different from scheduled or periodic task.

          use DBMS_SCHEDULER  to accomplish goal.

           

           

           

          How do I ask a question on the forums?

          https://forums.oracle.com/message/9362002#9362002

           

          post full & complete results from SQL below

           

          SELECT *  FROM V$VERSION;