Rosario
Posts: 54
|
| Posted: 06/02/2006, 5:17 AM |
|
I have a Table displaying escalation data i want emailed to my team hourly, is there a logic for this?
|
 |
 |
Benjamin Krajmalnik
|
| Posted: 06/02/2006, 7:06 AM |
|
There are a few ways you can accomplish this.
1. Write a windows service which runs in the background and monitors the
database (this is not CCS/ASP)
2. Write a script (in CCS) which performs the emailing, and schedule it
from within windows to run hourly (you are then not dependant on a browser
session being open with a refresh, and all this entais.
3. Have a page which refreshes - but now you are dependent on the browser,
so this is not reliable.
|
|
|
|
Rosario
Posts: 54
|
| Posted: 06/02/2006, 7:14 AM |
|
I would bet that the "Write a windows service" is going to be what i need, i have full access to the server. Know of any 3rd pty add ons?
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 06/02/2006, 10:34 AM |
|
Quote :I would bet that the "Write a windows service" is going to be what i need, i have full access to the server. Know of any 3rd pty add ons?
MS VS 2005? 
_________________
Vasiliy |
|
|
|
Edd
Posts: 547
|
| Posted: 06/02/2006, 8:16 PM |
|
If you use MSSQL, use a stored procedure to send emails.
An example can be found at
http://www.planet-source-code.com/vb/scripts/BrowseCate...B1=Quick+Search
This can be a scheduled jop in the database as well.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
Benjamin Krajmalnik
|
| Posted: 06/02/2006, 11:05 PM |
|
Vasily,
How about Clarion 6.x with SelfService from Capesoft. :)
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 06/03/2006, 9:40 PM |
|
Yeah, this is a joke.
Same as their book "how to call Clarion fm .Net and .Net fm Clarion".
But I purchased it even thought it is not published yet. :)
Sorry, guys, for off-topic.
_________________
Vasiliy |
|
|
|
marcwolf
Posts: 361
|
| Posted: 06/04/2006, 6:47 AM |
|
There is another way that I use and it works very well.
use CCS to create a web page that will do what you want it to do
Now create a VBS file (Visual Basic Script) and put in this code
Option Explicit
On Error Resume Next
' Declare our vars
Dim objWinHttp, strURL
' Request URL from 1st Command Line Argument. This is
' a nice option so you can use the same file to
' schedule any number of differnet scripts just by
strurl = "http://192.168.1.250/YOURWEBPAGE.ASP"
Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5.1")
objWinHttp.Open "GET", strURL
objWinHttp.Send
If objWinHttp.Status <> 200 Then
' If it's not 200 we throw an error... we'll
' check for it and others later.
Err.Raise 1, "HttpRequester", "Invalid HTTP Response Code"
End If
Set objWinHttp = Nothing
Dim objFSO, objFile
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\ScheduleProc.txt", 8, True)
objFile.WriteLine Now() & " | " & strUrl & " | Run "
objFile.Close
If Err.Number <> 0 Then
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("c:\ScheduleErr.txt", 8, True)
objFile.WriteLine Now() & " | " & strUrl & " | " & Err.Number & " | " & Err.Description
objFile.Close
End If
Set objFile = Nothing
Set objFSO = Nothing
Now create a recurring task in your scheduler and run it. It will Let you know when it was run from the logs and its success. Plus you can manually run it at any time from any location just by calling the web page
I use this for running 3 different tasks on the server.
Hope it helps
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 06/04/2006, 7:06 PM |
|
What is a joke?
I have an enie business pocess automation system runing around clarion
service. Over 100 users. MS SQL on the bakcend.
No problems at all.
|
|
|
|
Vasiliy
Posts: 378
|
| Posted: 06/04/2006, 11:00 PM |
|
The joke is to re-invent the wheel, especially using tools not supposed to build wheels.
I use Clarion since 1991 and like it, but use it for commercial DBMS only.
Benjamin, let's move this discussion to PM.
Sorry for off-topic again.
_________________
Vasiliy |
|
|
|
|
