Skip to main content

Hello everyone,

First of all, I apologise if there is already an entry on this and I have overlooked it. Maybe one of you has an idea how I could solve the following task:

I am looking for a way to run certain SQL queries on a daily basis and then send the results of these as a PDF by email, as part of my daily monitoring, so to speak.

I use the Smart Client for Windows in the following version:

Release: 6 Update 25
Build: 8597

My idea would have been to do this with the menu item ‘Monitor Schedules’ as a daily job, but I haven't quite figured out how to do this, or whether there might be a simpler solution to my problem.

Best regards
Lars

Hi ​@lgiessler 

At a high level, these are the steps to follow

  1. Create an RDLC report file using MS Visual Studios and create a report record in FSM using the report admin screen

     

  2. Use the ‘Notification Message' screen to create a notification message and configure that report in the notification record

     

  3. Create a ‘Scheduled Process’ to run daily (configurable) and execute perform_send_notification XML. 

    <perform_send_notification>
      <parameters>
        <distr_list_id>DISTRIBUTION_LIST</distr_list_id>
        <message_name>NOTIFICATION_MESSAGE</message_name>
        <check_time_limit>N</check_time_limit>
      </parameters>
     </perform_send_notification>


That is all more or less.

 

Cheers!

Reply


Terms & ConditionsCookie settings