Schedular in MSSQL 2000

Hi,

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

Thanks
tia_kamakshiAsked:
Who is Participating?
 
Kevin3NFConnect With a Mentor Commented:
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
0
 
Kevin3NFCommented:
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?
0
 
tia_kamakshiAuthor Commented:
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
that

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


0
 
tia_kamakshiAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.