+23Dear developers,
my goal is to create a list of all background jobs with a status of 'warning' within a week and send this list via email to a user. To achieve this, I wrote an SQL code and put it in a custom event.
In this case I don’t need the custom event trigger.
Or can I just use a condition in my SQL code?
How can I handle it?
Thank you in advance.
Best answer by Tharshan SM
Hi
For a Custom Event you need a trigger point to execute the event even for the workflow, so for this requirement in my opinion, there can be two options. One is through a modification, where you can create a utility function and register it as a Database Task, and schedule. This gives you the full control over.
The other, and best option since this is mainly SQL based query, is to use a Scheduled Quick Report, which can run automatically at the interval and email the generated list to the users.
Regards
+6Hi
For a Custom Event you need a trigger point to execute the event even for the workflow, so for this requirement in my opinion, there can be two options. One is through a modification, where you can create a utility function and register it as a Database Task, and schedule. This gives you the full control over.
The other, and best option since this is mainly SQL based query, is to use a Scheduled Quick Report, which can run automatically at the interval and email the generated list to the users.
Regards
+23Hi
I had a feeling for that.
But I just need to set up a trigger (somewhere) that will identify today as a specific day (e.g. Friday) and then initiate the event.
Otherwise the second option is fine too.
+23We will process the second option.
Thank you
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.