You can use the syntax of SQL query language to write queries.
Current date
You can use the custom syntax <rundate> to insert the date the query is run into the query results file.
Email group
When you use email groups in Query Scheduler, you must enter a job number or employee number in the query.
Note: Query Scheduler cannot use the User and User Supervisor email groups.
Example: SELECT a.* INTO #JobResults FROM (SELECT * FROM tblJB_Jobs where jobnumber in ('10050','10051'))as a
Example: SELECT a.* INTO #EmployeeResults FROM (SELECT * FROM tblPAY_Employees where employeenumber in ('65','161','200'))as a