Greeting all,

I need something that will run on my server
once every day, I need to query the DB,
also I can't use any *.exe or *.dll files,
currently using SQL Server 2k and ASP.

just a thought - should I use the SQL Trigger ?

Basically you can use the SQL Server Agent to do the trick.
Schedule a job and fire the query in the job and it will run whenever you like

Can I send an email thru the Agent ?

U C, I need to check every day witch user to charge,
if so than to charge his CC and send him an email.

Yes you can send email though the agent, as you would have found if you researched it yourself for 2 minutes.

Are you using a shared server as you will need to configure it.

Search SQL Books On Line for more info.

Another method is to use a sheduled task on the server if you have the permissions to set it up.

Cheers,
Andrew

I know that I can send an email
form the sql server but didn't explain my self good enough,
the thing is that I want to send an customized email
from my ASP, I need to know if there is a target that activate
my script on the server just like user is making a request..

also I can't configure the SQL Server or the
IIS Server as boat are sherd with others . . .