Schedular in MSSQL 2000

Posted on 2007-08-01
Medium Priority
Last Modified: 2010-03-19

I am using MSSQL 2000

I want to set a schedular in the SQL which checks the data in the table and filter all records from the table and send the emails to the person

How this can be done

Question by:tia_kamakshi
  • 2
  • 2
LVL 21

Expert Comment

ID: 19608836
Check books online for xp_sendmail, and pay pecial attention to the @Query parameter

To use SQL Server's mail in SQL 2000 you need a MAPI client installed on the server (typically Outlook) and a Profile.

There are alternative mail-sending options.

Do you need help on the setting up the query to get the records you need, or jsut the mail part?

Author Comment

ID: 19610528
Thanks for your reply.

Yes, I have never used this kind of functinality.

I read at http://msdn2.microsoft.com/en-us/library/ms189505.aspx

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

I have outlook installed on my system. Is this sufficeint to  use MAPI client and a Profile. What are these.

Please help me in configuring the things.

And what are the best alternative methods you have

Thanks allot

LVL 21

Accepted Solution

Kevin3NF earned 2000 total points
ID: 19610636
Outlook IS a MAPI client.  Log onto your server directly as the account that will be running the job, and connect to your exchange server.  That will force you to create a profile (or create it by default..I forget)

check out XP_sendmail in Books Online....they explain it better than I do

Author Comment

ID: 19618680

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question