Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can I use SQL Server Agent >> Jobs - to send a email reminder to an email address? Expand / Collapse
Author
Message
Posted Monday, June 24, 2013 9:53 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 6, 2013 4:06 AM
Points: 27, Visits: 82
Can I create a Job in SQL Server Agent...
- to send a simple email reminder to an email address?
Post #1466804
Posted Monday, June 24, 2013 10:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:03 PM
Points: 12,928, Visits: 12,347
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1466828
Posted Tuesday, June 25, 2013 9:01 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 9:33 AM
Points: 407, Visits: 968
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
Post #1467217
Posted Tuesday, June 25, 2013 9:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 4:03 PM
Points: 12,928, Visits: 12,347
Thanks for the correction Tom.

_______________________________________________________________

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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1467225
Posted Wednesday, June 26, 2013 8:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, September 6, 2013 4:06 AM
Points: 27, Visits: 82
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:
[url=http://www.codeproject.com/Articles/485124/Configuring-Database-Mail-in-SQL-Server][/url]
Post #1467702
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse