Can I use SQL Server Agent >> Jobs - to send a email reminder to an email address?

Question

Can I use SQL Server Agent >> Jobs - to send a email reminder to an email address?

mrichardson 57577

Right there with Babe

Points: 739
More actions
June 24, 2013 at 9:53 am

#294975

Can I create a Job in SQL Server Agent...
- to send a simple email reminder to an email address?

Viewing 5 posts - 1 through 4 (of 4 total)

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

mrichardson 57577 (6/24/2013)
Can I create a Job in SQL Server Agent...
- to send a simple email reminder to an email address?

yes. Look up xp_sendmail. Or you could create an SSIS package to do this. There are a number of ways this can be accomplished.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

TangoVictor SSChampion Points: 10975 More actions · Answer 2

look at dbmail instead, you want to steer clear of xp_sendmail.

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. To send mail from SQL Server, use Database Mail.

but yeah you could just run a tsql job stop that uses dbmail.

http://msdn.microsoft.com/en-us/library/ms175887(v=sql.105).aspx

Sean Lange SSC Guru Points: 286590 More actions · Answer 3

Thanks for the correction Tom. :blush:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

mrichardson 57577 Right there with Babe Points: 739 More actions · Answer 4

thanks,

its working now.

we already had dbmail set up so managed to just use something like this to send mail:

EXEC msdb.dbo.sp_send_dbmail
@recipients = 'youremailid@xxxx.com',
@body = 'Database Mail Testing...',
@subject = 'Databas Mail from SQL Server';

from here: