The SQL Receive adapter is a polling adapter, it will execute the configured query or stored procedure at an interval you specify and return some records as an Xml message, or possibly no message if there are no records that meet the criteria.
e.g
Create PROCEDURE bts_PollTable AS
SELECT * FROM myTable WHERE Status='New' FOR XML AUTO, ELEMENTS
UPDATE myTable SET Status='Processed' WHERE Status='New'
GO