Schedule Jobs


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Schedule Jobs

  1. #1
    Peter Guest

    Schedule Jobs


    I have a problem about ASP. The problem is how to schedule jobs or execute
    send email function everyday if the condition is valid which comes from the
    database.

    The situation is how to write the reminder via email. I am using SQL Server
    7.0. (Like yahoo's calendar which has a function to remind the user something
    or events will happen!) How to do this? Should I only using ASP script to
    do this or using SQL server to do this ?

    I know SQL server has SQL Mail, but the fact is it connot support MS Outlook
    Express. So, what should I do ? Thx.

  2. #2
    Rob Taylor Guest

    Re: Schedule Jobs


    You need to set a trigger on SQL Server to send the mail.
    I do not know what you mean as far as SQL Mail not supporting outlook. That
    should not matter. You can alsu use the Windows Script Host.



    "Peter" <saiips@hongkong.com> wrote:
    >
    >I have a problem about ASP. The problem is how to schedule jobs or execute
    >send email function everyday if the condition is valid which comes from

    the
    >database.
    >
    >The situation is how to write the reminder via email. I am using SQL Server
    >7.0. (Like yahoo's calendar which has a function to remind the user something
    >or events will happen!) How to do this? Should I only using ASP script to
    >do this or using SQL server to do this ?
    >
    >I know SQL server has SQL Mail, but the fact is it connot support MS Outlook
    >Express. So, what should I do ? Thx.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center