I've got a web page (VB.Net 2005) that takes in information, and submits it
to a sql server 2000 database
There is a 'Status' field - at that point, when the info is submitted, the
status field has 'submitted' in it.
What I'd like to do, is, if it does not change into an "approved" or
"denied" status in 72 hours (a different web page), we need the
functionality to be able to send an email it to the approver's supervisor.
this a little beyond my expertise - any ideas here? 3 1322
you should write a sqlagent job or a windows service to do this.
-- bruce (sqlwork.com)
Elmo Watson wrote:
I've got a web page (VB.Net 2005) that takes in information, and submits it
to a sql server 2000 database
There is a 'Status' field - at that point, when the info is submitted, the
status field has 'submitted' in it.
What I'd like to do, is, if it does not change into an "approved" or
"denied" status in 72 hours (a different web page), we need the
functionality to be able to send an email it to the approver's supervisor.
this a little beyond my expertise - any ideas here?
I've never done that - - can you point me to a web source with a tutorial on
sqlagent jobs - - and how this type of deal would fit in?
"bruce barker" <no****@nospam.comwrote in message
news:Ot**************@TK2MSFTNGP03.phx.gbl...
you should write a sqlagent job or a windows service to do this.
-- bruce (sqlwork.com)
Elmo Watson wrote:
>I've got a web page (VB.Net 2005) that takes in information, and submits it to a sql server 2000 database There is a 'Status' field - at that point, when the info is submitted, the status field has 'submitted' in it.
What I'd like to do, is, if it does not change into an "approved" or "denied" status in 72 hours (a different web page), we need the functionality to be able to send an email it to the approver's supervisor.
this a little beyond my expertise - any ideas here?
I've figured out how to create a job - - and I've figured out how to query
the table for the desired items.
What I don't know how to do now, is to iterate through the data which was
returned, and send an email (email address in the data), based on that
data....
/??????
"Elmo Watson" <ew@yahoo.nospam.comwrote in message
news:uA**************@TK2MSFTNGP05.phx.gbl...
I've never done that - - can you point me to a web source with a tutorial
on sqlagent jobs - - and how this type of deal would fit in?
"bruce barker" <no****@nospam.comwrote in message
news:Ot**************@TK2MSFTNGP03.phx.gbl...
>you should write a sqlagent job or a windows service to do this.
-- bruce (sqlwork.com)
Elmo Watson wrote:
>>I've got a web page (VB.Net 2005) that takes in information, and submits it to a sql server 2000 database There is a 'Status' field - at that point, when the info is submitted, the status field has 'submitted' in it.
What I'd like to do, is, if it does not change into an "approved" or "denied" status in 72 hours (a different web page), we need the functionality to be able to send an email it to the approver's supervisor.
this a little beyond my expertise - any ideas here?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Alexander DEJANOVSKI |
last post by:
Hi all,
I'm starting a new project to develop an Open-Source EAI server in Python
and I'm looking for motivated developpers and testers.
It is inspired by Open Adaptor (www.openadaptor.org), but...
|
by: tex-music-admin |
last post by:
Your mail to 'TeX-music' with the subject
Re: Your application
Is being held until the list moderator can review it for approval.
The reason it is being held:
Post by non-member to a...
|
by: gs-code-review-bounces |
last post by:
Your mail to 'gs-code-review' with the subject
Re: Application
Is being held until the list moderator can review it for approval.
The reason it is being held:
Post by non-member to a...
|
by: Istvan Buki |
last post by:
Dear C++ gurus,
I'm having some problems inserting some template classes into containers.
I'm looking for ideas, suggestions,... on how to achieve this but first let
me explain my problem....
|
by: Larry Rekow |
last post by:
ve built various web apps using Frontpage and/or ASP and Access, but
now I'm trying to figure a way to do the following:
My friend gets parts lists in invoices (they are in an excel
spreadsheet)...
|
by: m3rajk |
last post by:
I've recently become the defacto DBA of two MSSQL databases at work because I am the only one with SQL experience. I have been asked to do some tasks with the databases but this requires and...
|
by: bcannon |
last post by:
At Guido's suggestion, a new mailing list has been created named
Python-Ideas (http://mail.python.org/mailman/listinfo/python-ideas).
This list is meant as a place for speculative, pie-in-the-sky...
|
by: Brent White |
last post by:
We're looking into building an in-house integrated enterprise system
to manage inventory, work-in-process, and finances, among others. I
am somewhat familiar with VB.NET (veteran VB 6 programmer)...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |