Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Timer
- Thread starter PeteCan
- Start date
yes there is a way (assuming only one page is open)
use the timer funcion of javascript, set it to 20 minutes, open a popup window (if u do not want to disturb the current page displayed) and send the mail, close the popup window using javascript.
in the original page reset the timer.
use the timer funcion of javascript, set it to 20 minutes, open a popup window (if u do not want to disturb the current page displayed) and send the mail, close the popup window using javascript.
in the original page reset the timer.
- Thread starter
- #3
The problem i have is that this is a helpdesk type function so the a call is placed to the helpdesk, they then log the call in the database.
They may have several calls going at once so won't necessarily be sitting in any particular record so the suggested functionality would not suffice. I presume I need a process that sits in the background and performs regular checks?
They may have several calls going at once so won't necessarily be sitting in any particular record so the suggested functionality would not suffice. I presume I need a process that sits in the background and performs regular checks?
I take it each record (or "call"
has a status of open when you add it and then the status gets changed when a helpdesk member starts dealing with it? You want to notify someone when a call hasn't been dealt with within 20mins of being opened?
If this is correct, I would use some kind of scheduled job in the DB rather than an ASP page. eg, in SQL Server you could set up a job in SQL Agent that ran every 20mins, running a query similar to this:
--James
has a status of open when you add it and then the status gets changed when a helpdesk member starts dealing with it? You want to notify someone when a call hasn't been dealt with within 20mins of being opened?If this is correct, I would use some kind of scheduled job in the DB rather than an ASP page. eg, in SQL Server you could set up a job in SQL Agent that ran every 20mins, running a query similar to this:
Code:
SELECT * FROM table_name
WHERE status = 'open' AND opendate < DATEADD(n, -20, getdate())- Thread starter
- #5
Can you do anything with a Macro in Access? I'm assuming you've posted on the MS Access forum?
A not so pretty way would be to query the database for open recs when you are performing other operations. If the application is used quite frequently, but just have an individual who is sitting on a open record, then when other users perform an action, your operation will check open date/status field and send an email accordingly. Just a thought.
_______________________________
regards,
Brian
AOL IM: FreelanceGaines
A not so pretty way would be to query the database for open recs when you are performing other operations. If the application is used quite frequently, but just have an individual who is sitting on a open record, then when other users perform an action, your operation will check open date/status field and send an email accordingly. Just a thought.
_______________________________
regards,
Brian
AOL IM: FreelanceGaines
- Status