Daily Alert timing

This is currently a feature request for the DPA product. The only way I know to do it is to actually create it at the time you want it to run. The 24 hour clock starts then, so it will run at that same time every day. Not ideal if you want it to run at 2 AM granted...

vote for the feature here.

If you edit the alert (add a comment or whatever) and save it again, it resets the run time to restart from the save time. There is some couple of minutes of lag time between the edit, and the repository tables being updated so it is not precise.

If you're feeling brave, have a look at the repository tables con_alert (id, frequency for the alert) and con_alert_db (alertid and lastrun columns).

I suspect the lastrun column may be used to determine the next run time based on the frequency column (minutes) in con_alert. (test edit as above changes the lastrun time)

If you were to, say, manually update the lastrun value to be at a date with the time set to 06:30  then it may just magically run at that time.

This is just an educated guess, not recommended by SW, update tables at your own risk, YMMV, YOLO, etc etc

I did change the lastrun field yesterday and it ran this morning at the time I wanted it to run. As gcp posted, this is NOT recommended by SW but it did work.

It would also be nice to not only pick the time the daily alert runs but the day. i.e. I want my alert to run every day of the week except for Sunday.

I believe in the past we'd tried that solution, but found out that there were other dependencies and it was not as easy as updating that table... Something is getting written on the java side in a config file. Thinking editing the script is the safer way to go.

I'm glad it worked for you mjkpref​. As mandevil​ says, I think there is another component in the scheduling mechanism, as it doesn't seem to be a reliable trick.

Maybe SW can consider amalgamating these couple of requests?  Basically, give us a decent calendar mechanism to set up blackouts, alerts etc.?

In the meantime - vote them up!