How to send an alert based on SQL Query results
I would like to add a "T-SQL Statement Task" that will execute a query and send me an email alert based on the results of the query.


You can do this using a TSQL Task and using sp_send_dbmail as below :

EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'your mail profile',
    @recipients = 'dba@company.com',
    @body = 'results -- some body goes here',
    @subject = 'Sensible subject goes here ',
-- to send file attachments (if any)
    @file_attachments = 'L:\logs.TXT',
  -- send query results 
    @query = 'Select Cast(case when count(inventory.items) &gt; 1000 then 1 else 0 End as bit) as SendAlert
From Inventory';