• Maybe this has already been said in a different way, but this is what I've done, and I think it works -- please feel free to try it out and post your findings.

    I created a table SchedTable of dates that I need a data-driven SSRS report to go out, and set the query for the recipient list, fields, etc to:

    SELECT 'me@awesome.com' as EmailAddress, 'blah' as parameter1, EmailDate from SchedTable where convert(varchar(10), getdate(),102) = EmailDate

    I scheduled this to run daily in the SSRS scheduler, but since the query only returns data for the schedule dates in my table, the report is only sent out on the dates I want.