sqlrd22 (10/15/2012)
I have a job in SQL Server Agent that sends the results of a query to my email twice daily, however most of the time this query will not have any results. I, therefore, wish for the results of the query to only be sent to me when there are actual results from the query.At the moment the query results just come with the headings and a message saying (0 rows affected).
Are you using T-SQL to generate the report and send mail?
From what you say it sounds like your setup is like the below:
1) SQL Agent Job runs twice a day.
2) There is a step in the job which generates the report and send mail.
If that's how it is then why not use an IF statement to check for size of record set of your report before you use the sp_send_dbmail?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn