• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 222
  • Last Modified:

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.
0
horalia
Asked:
horalia
  • 2
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now