Post reply

Database Mail

  • July 3, 2008 at 3:20 am

    #122312

    Hi Guys

    Have a question on Database mail. I know how to set it up but where to from there. How do I go about seng an email to someone with a document attached and have the process automated?

    Regards

    IC

  • July 3, 2008 at 5:22 am

    #837728

    Did you read about sp_send_dbmail in BOL?

    [font="Verdana"]Markus Bohse[/font]

  • July 3, 2008 at 5:26 am

    #837729

    In SQL server:

    Under management - Database mail- You need to setup a new e-mail profile and corresponding smtp account

    You can use the stored procedure to test if its working:

    sp_send_dbmail

    for more info check BOL.

    ------------------------------------------------------------
    Application Architect and Developer @ Traffic4u
    Visit my profile on LinkedIN

  • July 3, 2008 at 5:42 am

    #837741

    Since database mail saves messages and attachments in MSDB you'll also want to look at scheduling these two stored procedures as part of routine maintenance.

    [font="Courier New"]msdb.dbo.sysmail_delete_mailitems_sp

    msdb.dbo.sysmail_delete_log_sp[/font]

    Look for the following topic in BOL for an example of how to do that:

    How to: Create a SQL Server Agent Job to Archive Database Mail Messages and Event Logs

  • July 4, 2008 at 10:17 am

    #838398

    setup the SMTP profile in your DB mail system,then have a test.

    [font="Arial"]MCDBA, MCITP (DB Dev, DB Admin), MCSE,MCTS, OCA 10g[/font]

  • July 5, 2008 at 7:31 am

    #838498

    Do People ever refer to BOL First.

    Maninder
    www.dbanation.com

  • July 7, 2008 at 6:23 am

    #838786

    [font="Verdana"]Hi,

    Refer the article "Database Mail", I hope this could help you![/font]

    Regards..Vidhya Sagar
    SQL-Articles

  • July 7, 2008 at 7:15 am

    #838845

    Thanks. I have created the stored proc that sends the mail.

Viewing 8 posts - 1 through 7 (of 7 total)

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