How tu run SQL on BusinesObject Enterprise

Posted on 2011-05-13
Last Modified: 2012-05-11
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.
Question by:horalia
    LVL 22

    Accepted Solution

    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...

    Author Comment

    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!
    LVL 22

    Expert Comment


    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now