Post reply

HOW TO SEND AUTOMATIC EMAILS USING SQL JOB

  • July 15, 2008 at 3:53 am

    #184618

    HI, CAN ANY ONE TELL ME HOW TO WRITE A SQL JOB FOR SENDING AUTOMATIC EMAILS WHEN A CERTAIN DATE IS REACHED.

  • July 15, 2008 at 3:59 am

    #842907

    Hi Santosh,

    A new feature in SQL Server 2005, Database Mail, is an enterprise solution for sending e-mail messages from the Microsoft SQL Server 2005 Database Engine.

    To use Database Mail, you must explicitly enable Database Mail using the Database Mail Configuration Wizard.

    Database Mail Configuration Wizard performs these tasks:

    Set up Database Mail.

    Manage Database Mail accounts and profiles.

    Manage profile security.

    View or change system parameters.

    Cheers,
    Hari
    Tips & Tricks for SQL BI Developers

  • July 15, 2008 at 7:01 am

    #843057

    After configuring Database mail you can use the SP sp_send_dbmail to send an email. (See also BOL)

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply