How to send mail everyday at 3:00 AM in SQL Server 2000

• Hem-586205

  SSC Journeyman

  Points: 90

  More actions

  February 14, 2008 at 1:53 am

  #62338

  Hi

  I want some ides rearding sending mail at specified time. I want to send mail at everyday 3:00AM from SQL Server. I have stored procedure to send mail.

  Thanks in advance

  Hem

• Vijaya Kadiyala

  SSCrazy Eights

  Points: 9119

  More actions

  February 17, 2008 at 3:12 pm

  #779214

  Hi,

  There are two steps.

  1) Sending out an email from SQL Server. Use the below link

  http://classicasp.aspfaq.com/email/how-do-i-send-e-mail-from-sql-server.html

  2) Schedule this activity at 3:00PM everyday. For this you need to SQL Server jobs.

  http://www.databasedesign-resource.com/sql-server-jobs.html

  Thanks -- Vj

  http://dotnetvj.blogspot.com

  Thanks -- Vijaya Kadiyala
  www.dotnetvj.com
  SQL Server Articles For Beginers