How tu run SQL on BusinesObject Enterprise

I need to send out via email a count of a SQL table and I would like to do so using BusinessObjects. I don't want to create a report for such a simple query which would only contain one number. Can SQL be run by the Central Management Console and then have the result be sent via SMTP? Thanks.
horaliaAsked:
Who is Participating?
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
I believe you would need to create a report for that.  If this is SQL Server you can set up an "Agent" to do run on schedule and send an email...
0
 
horaliaAuthor Commented:
It is SQL Server. How can an Agent be set up? I already have a job that runs on a daily basis which populates a table. I would like the count to go out after the job has run. Any help will be much appreciated. Thanks!
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.