+4I created a custom API that returns one of two values (let’s say ‘0’ and ‘1’). It needs to run every four hours. If the value is ‘0’, then an email needs to go out.
While I don’t need help with creating the database task and scheduling it to run, I don’t know how to then get an email to send. Do I make an Event? If so, how do I tie it to the scheduled task? Do I do something else??
Let’s assume the Scheduled Task is named “Neraks_Amazing_Task”.
Thanks!
Best answer by EntShehaM
In your custom package I believe you have a function already written to get the return values (0 or 1) so basically you can create a procedure in the declared custom package and inside that procedure do an IF statement to check your pre-written function returns value is equal to 0 then you can trigger the email sending by using Command_SYS.Mail(). Once in every 4 hours when the schedule execute it will check your return value whether 0 or 1 upon your return value, action will perform (in this case send an email).
Cheers!
+5
In your custom package I believe you have a function already written to get the return values (0 or 1) so basically you can create a procedure in the declared custom package and inside that procedure do an IF statement to check your pre-written function returns value is equal to 0 then you can trigger the email sending by using Command_SYS.Mail(). Once in every 4 hours when the schedule execute it will check your return value whether 0 or 1 upon your return value, action will perform (in this case send an email).
Cheers!
+5AHA! I knew I was making it more complicated! THANK YOU!!
Glad that clarification helps you to fulfill your requirement.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
