Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
7
Erster Beitrag:
vor 6 Monaten, 3 Wochen
Letzter Beitrag:
vor 6 Monaten, 3 Wochen
Beteiligte Autoren:
Peter Holemans, Sam Asid, ccc2, Ccc2

WX 21: Periodic Sending of Text Alerts

Startbeitrag von Sam Asid am 28.03.2017 13:04

Dear All,

This may sound a bit elementary but I would rather get help starting than struggle through a mess.

I would like set up a system where one person would populate a HFSQL classic with tasks that need to be done by many people over a period of up to one month period. I want to come up with a app that would periodically search a database and send out alerts a day, an hour and 15 minutes before a task should be done.

How should I approach this? I have read about timer function but I wonder how that will work. How do I get the alerts to go out without any human intervention.

Thanks in advance.

Best regards,

Sam.

Antworten:

Hi Sam,

Some tips:
- Use a central HFSQL Server database instead that keeps all data central...
- Create stored procedures in the HFSQL server that do the emailing based on the data in the database
- Add the stored procedures to the HFSQL server scheduler and have them run e.g. every 5 minutes Monday through Saturday

This should give you a start...

Bye,

Peter Holemans

von Peter Holemans - am 28.03.2017 13:52
Create windows console application to do the reading data and sending.
Use windows scheduler to call the program

von Ccc2 - am 28.03.2017 14:15
Hi CCC2,

Your solution has some disadvantages: the user (under which that Windows task manager is running) has to be logged on, and the computer needs to be on...

Alternative to the HFSQL Server solution in my earlier post and yours:
A service running on a server (always on) as a system user might be an alternative. That means that the job will run even if no user is logged in.

All the best,

Peter Holemans

von Peter Holemans - am 28.03.2017 14:58
Hi Peter,

I don't know which old version of windows scheduler you are talking about.

you can set scheduler to run without user need to login.

von ccc2 - am 28.03.2017 16:24
Hi CCC2,

You're absolutely right (and I never must have paid attention to that option so I must be blind :eek: )...

I rarely use the Windows Scheduler as I implement most of this kind of repetitive background processes in general as services rather than have it execute via the scheduler. But indeed, a scheduled option is also a viable alternative with this option in mind.

Thanks for pointing it out!

Cheers,

Peter Holemans

von Peter Holemans - am 29.03.2017 07:27
Hello All,

I must apologize I was off my laptop for a couple of days to attend to some counseling matters. Thank you for the leads. I will explore these options and let you know how it goes.

Enjoy the weekend.

Best regards,

Sam.

von Sam Asid - am 31.03.2017 11:08
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.