--Once SQLMail is configured, you can send email via Query Analyzer:

exec master..xp_sendmail 'jbes@xyzg.com',
@subject = 'Total number of rows in the batch table',
@query = 'select count(*) from demopremierapp60..batch'