Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 22nd, 2004, 03:05 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default ASP & DTS in SQL server

hello people!
i am working on a customer care project with ASP (VB script) as the front end & MS SQL server as the back end
the description follows:

i am getting complaints from users which i will assign to engineers
i want to start a countdown timer on hitting a button based on the priority....
ie. i set the level of a particular record & press the save button....
if the level is 1, then a countdown timer of 15 minutes should be started & when the timer reaches 0,
an email should be generated & sent to me & another user that i will specify.
for level 2, timer should be 45 minutes & for level 3, it should be 180 minutes
how would this be done???

i want the provision for being able to run multiple timers concurrently


About the email notification, every 'complaint' is given a priority level and based upon it the engineer is supposed to fix
the problem. What i want is that once the prescribed time for a given 'complaint' expires,
an email is sent from the server end (sql server) to the relevant people,
in this case it should be sent to the coordinator (who forwards the complaint to an engineer)
and the user who logged in the complaint.How i figured this would work was by implementing a countdown timer for
every priority level, at the timeout of which the email is triggered by the server, automatically.
What i havent been able to figure out is how to implement the timer and connect it to the email trigger
or even if its going to work like that at all. Could someone please help me in this and also if someone could please tell me
what exactly needs to be done to set up an email service e.g what email component to use, how to configure it etc.






now i tried posting this topic in the ASP forum where i was suggested to use a DTS for the above
i am not sure how a DTS works & i tried to look it up on the net but didnt get anything useful.....
can someone please help me?
i am racing against time and all help in this matter would be greatly appreciated.!!!

thanks!!!
 
Old March 22nd, 2004, 06:29 AM
joefawcett's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

This might help. Sounds like what you need if you can install it etc.

http://www.microsoft.com/sql/NS/default.asp


--

Joe
 
Old March 24th, 2004, 12:48 AM
Authorized User
 
Join Date: Mar 2004
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

my problem remains... as i aint working on .NET & this notifiation pack works only with .NET
any other way???





Similar Threads
Thread Thread Starter Forum Replies Last Post
asp.net & sql server database naeem.net ASP.NET 2.0 Professional 13 July 18th, 2007 02:10 PM
ASP.NET 2.0 & SQL Server 2000 / 2005 Hosting NonStopMark ASP.NET 2.0 Basics 1 January 1st, 2007 02:56 AM
ASP.Net & SQL Server chenwf2006 ASP.NET 2.0 Basics 0 December 17th, 2006 03:54 AM
ASP.NET & SQL Server 2K Stored Procedure kwilliams ASP.NET 2.0 Basics 7 May 10th, 2006 12:55 AM
ASP & DTS in SQL server a_pathak SQL Server DTS 1 March 22nd, 2004 09:23 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.