Send polling based alerts?

>> Toad will run the queries on a schedule
Thanks,
I've been meaning to do get Toad anyway.
Maybe it's finally time.
I'm wondering if anyone has ever run a program on a recurring schedule that queries and sends alert(s)?


I currently have a BPM that will send an alert when criteria are met.
However the alerts may not be "timely"... since it is only triggered when a transaction takes place.
Some related information can be changing between transactions.

If not inside of E9, maybe with SQL.or 3rd party products?

I have tried a dashboard that auto-refreshes (and reports) but... users prefer email alerts.


Thanks
 






What information is changing relevant to the alerts... can you create a BPM for them?

>> can you create a BPM for them?
I don't think so, but maybe I've missed something?

>>What information is changing relevant to the alerts...
Labor time  while they are clocked in, LaborDtl.ActivTrans is true.
When starting activity, the clockintime is recorded, then no other events until they end activity.
Won't know the labor exceeds the estimate until after it's already happened.

My current BPM alerts only trigger  when employees start / stop activities.
- JobOper data directive that compares ActProdHrs to EstProdHrs & alerts if over.

In a perfect world, we'd send alerts if time exceeds the estimate... while they are still clocked in.

The dashboard captures this, with some conditional formatting to display excesses.
But.... they would prefer alerts since aren't at their desks to monitor.

Looking for something "Polling" based that would check active jobs at regualr intervals & send alerts.. just for the exceptions.



Thanks in advance for any thoughts...

I don’t think there is a way to schedule a batch or cron type of jobs to poll.

 

It would be nice.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, September 17, 2015 10:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Send polling based alerts?

 

 

I'm wondering if anyone has ever run a program on a recurring schedule that queries and sends alert(s)?


I currently have a BPM that will send an alert when criteria are met.
However the alerts may not be "timely"... since it is only triggered when a transaction takes place.
Some related information can be changing between transactions.

If not inside of E9, maybe with SQL.or 3rd party products?

I have tried a dashboard that auto-refreshes (and reports) but... users prefer email alerts.


Thanks
 




 

>>>>I don’t think there is a way to schedule a batch or cron type of jobs to poll.
>>It would be nice.
Thanks, I was pretty sure not from E9.
The need just comes up from time to time
#ygrps-yiv-1730636685 P.ygrps-yiv-1730636685b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1730636685 LI.ygrps-yiv-1730636685b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1730636685 DIV.ygrps-yiv-1730636685b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1730636685 TABLE.ygrps-yiv-1730636685b1e7fd89-0279-4ffe-a16a-1f1bcba0d537Table { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1730636685 DIV.ygrps-yiv-1730636685Section1 { }

There is not really a built in method for this which is why we created this 


Note our E10 version of this includes a new business object you can define All the logic then in a new BPM on the new Business object which makes things easier.



Regards

On 19 Sep 2015, at 01:57, bruce.d.ordway@... [vantage] <vantage@yahoogroups.com> wrote:

 

>>>>I don’t think there is a way to schedule a batch or cron type of jobs to poll.
>>It would be nice.
Thanks, I was pretty sure not from E9.
The need just comes up from time to time



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
DDI:  +44 121 314 1179
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

>>User Program Scheduler
This looks like what I had in mind.
Requesting some more details from the web site.

Thanks
You can do SQL queries in Toad and alert based on results. Toad will run the queries on a schedule.