looking for ideas on an approval type application

  • Thread starter Thread starter Elmo Watson
  • Start date Start date
E

Elmo Watson

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?
 
you should write a sqlagent job or a windows service to do this.

-- bruce (sqlwork.com)
 
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?
 
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....

/??????
 
Back
Top