|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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
|
||||
|
||||
|
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
|
|||
|
|||
|
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
|
||||
|
||||
|
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
|
||||
|
||||
|
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
|
|||
|
|||
|
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 Powered by ASP.Net |
|
#7
|
||||
|
||||
|
Quote:
but are you sure it's wise to show us the dark side? ![]() |
|
#8
|
|||
|
|||
|
Quote:
It's the new "bright side" There was a good example already, so I felt it necessary ![]() |
|
#9
|
|||
|
|||
|
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
|
|||
|
|||
|
Quote:
i only know VB .. that was years ago using visual studio 97 .. is that still usable? my god .. |
|
#11
|
||||
|
||||
|
Yeah you should have no problem writing this in vb
|
|
#12
|
|||
|
|||
|
hi there
me again. if using the enterprise manager, is it more advisable? wadya guys think? appreciate ur advise |
|
#13
|
|||
|