Steffi1013
MIS
I would like to set up a job that will email results from a query but if there are no results, it doesn't send the email. Any recommendations on how to do so??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Email if have query results
- Thread starter Steffi1013
- Start date
- Status
if exists (query here)
begin
send email
end
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
begin
send email
end
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
mutley1
MIS
- Jul 24, 2003
- 909
DECLARE @RowCount int
SET @RowCount =0
SELECT @RowCount =count(*)
FROM MyTable
WHERE myfield = 'x'
if @RowCount > 0
BEGIN
EXEC xp_sendmail @recipients = 'xxxxxx@xxxxxx.com',
@message = 'This is a message to the user.',
@subject = 'This is the email subject.'
END
SET @RowCount =0
SELECT @RowCount =count(*)
FROM MyTable
WHERE myfield = 'x'
if @RowCount > 0
BEGIN
EXEC xp_sendmail @recipients = 'xxxxxx@xxxxxx.com',
@message = 'This is a message to the user.',
@subject = 'This is the email subject.'
END
- Status
Similar threads