To create the SAP Query, go to SQ01.
Use SQ02 to create a program name for your query (Menu Query-> More Functions -> Display Report Name).
To schedule the SQP Query (use program name from previous step), use SM36 or SM36WIZ (WIZ – wizard where the conditions can be defined).
Output of the scheduled job can also be sent via email, Goto Exec. In Target, there is a recipient list button next to that in SM36, user name can be provided there.
As a alternate approach, you could also create a report that produces the same result as a query and this can be scheduled