how can a result be collected directly to e-mail body (or even better - subject?) via Automation (and scheduling) and sent , without having attachments?
example - select query gives 1 row of 8 digit integer and i do not need it to be sent to report (Excel), but i would prefer it to be sent via mail directly
select count(id) from emp_credentials
where emp_status = ‘CU’
and dep_code not in (‘mark’,‘sale’)
result is 17
my aim is to schedule it for automatic run every Friday at 17.10,
but i cannot view attachment on my phone, so i would need this result directly in subject or body