|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 28th, 2008, 07:24 AM
|
|||
|
|||
|
General Question - In need of advise
Hi Guys
I need some advise .. I am absolutely clueless on what i need to do ..  The company i'm wrking at right now already has a ASP system running capturing data from its employees. And usually the supervisor will launch another part of the application whereby to check out the information that has been keyed in. Now comes in my part.. they want to run an automated program that will monitor the inputs by the staff .. and at the same time, send an email to update the supervisors after 15min or so.. i've never done this b4. any idea wat is it called? kinda desperate i suppose... pls help. thanks!
|
|
#2
May 28th, 2008, 08:22 AM
|
||||
|
||||
|
Is the data being input stored in an MSSQL database? If so, it should be possible to write a stored procedure that is executed by a job every 15 minutes or so.
__________________
Wolffy ------------------------ Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Rework for your specific environment may be required. Void where prohibited by law. Not valid in California. Your mileage may vary. Not FDIC insured
|
|
#3
May 28th, 2008, 11:59 PM
|
|||
|
|||
|
Quote:
Hi Wolffy yes, the data's being stored in a MS SQL 2000. When u mentioned, writing a stored procedure, is this done on the MS SQL 2000 ?
|
|
#4
May 29th, 2008, 01:30 AM
|
||||
|
||||
|
Yes stored procedures are stored within SQL, Then language they are written in is T-SQL, you will need enterprise manager for SQL 2000 or SQL Server Management Studio for more recent versions.
If you have access to the server then I would suggest writing a page which gathers the emloyee submissions and emails them to the right person, then run a scheduled task at intervals which executes the page. You will not be able to do this unless you have access to a server which is always on and always online.
__________________
For my first trick watch me turn a zero into a one...
|
|
#5
May 29th, 2008, 01:52 AM
|
||||
|
||||
|
I'm not sure Stored Procedures can send emails.. ?
maybe it would be more simple for you to write full scale application in VB, C++ or even .NET that will run in the background or as Windows Service, query the database and perform the desired actions. are you familiar with any of the above programming languages?
|
|
#6
May 29th, 2008, 06:39 AM
|
|||
|
|||
|
Yup, you can. Here's an example: Sending email with stored procedure
__________________
jmurrayhead Did I help you out? Make me popular by clicking the  icon!New Members:Proper way to post a question .Net Help
|
|
#7
May 29th, 2008, 08:22 AM
|
||||
|
||||
|
Quote:
but are you sure it's wise to show us the dark side? 
|
|
#8
May 29th, 2008, 08:26 AM
|
|||
|
|||
|
Quote:
It's the new "bright side"  There was a good example already, so I felt it necessary 
|
|
#9
June 9th, 2008, 01:24 AM
|
|||
|
|||
|
hi guys
down on my luck, had a road accident, now on my bed .. at home FINALLY!! i will see what's the update's like and i will update u guys again! appreciate this people thank you so much fj
|
|
#10
June 9th, 2008, 11:12 PM
|
|||
|
|||
|
Quote:
i only know VB .. that was years ago using visual studio 97 .. is that still usable? my god ..
|
|
#13
June 10th, 2008, 06:56 AM
|
|||
|
|||
|
Quote:
Absolutely. Enterprise Manager gives you several options and tools.
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > General Question - In need of advise |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
