Pentaho用户控制台报表调度及邮件发送方法咨询

Hey there! Let me walk you through how to schedule a report in Pentaho User Console (PUC) and set it up to send to your target email address. I’ve done this dozens of times, so I’ll break it down into clear, actionable steps for you.

• First, log into your PUC account. Navigate to the report you want to schedule—you can find it in the Browse Files section, your favorites, or any custom folder you’ve set up.
• Hover over the report and click the Schedule option (it’s usually a calendar-shaped icon, though the exact look might vary slightly by PUC version).
• This opens the scheduling wizard. Start with the Schedule Details tab:
  • Give your schedule a descriptive name (like "Weekly Inventory Report - Every Monday") so you can spot it easily later.
  • Pick your frequency: choose between One-Time, Daily, Weekly, Monthly, or Cron (use Cron if you need a super custom schedule, like every 2nd Thursday of the quarter).
  • Set the start date/time, and if it’s a recurring schedule, add an end date if you don’t want it running forever.
• Next, jump to the Parameters tab (only if your report has user-defined parameters). Fill in the values the scheduled run will use—these are fixed for the schedule, so double-check they make sense for the timing of the run.
• Now head to the Notifications tab—this is where we’ll set up the email delivery.

• In the Notifications tab, click Add Notification and select Email from the dropdown menu.
• Fill out the email fields:
  • To: Enter your target email address(es)—separate multiple addresses with commas if needed.
  • Subject: Customize this to be clear (e.g., "Monthly Sales Report - ${DATE}" uses the ${DATE} variable to auto-include the run date, which helps recipients track when the report was generated).
  • Message: Add a quick note explaining the report’s purpose, like "Attached is the monthly sales performance report for your review."
• Under Attachments, make sure the box for attaching the report is checked. Then select your preferred output format—PDF, Excel, CSV, etc.—whichever works best for your recipients.
• Use the CC or BCC fields if you need to send copies to additional stakeholders or yourself for verification.
• Once all settings look good, click Save to activate the schedule.

• Before you start, confirm your Pentaho server’s email settings are configured correctly. Your admin needs to set up SMTP details in the pentaho-server/pentaho-solutions/system/mail/mail.properties file—this includes the SMTP server address, port, authentication credentials, and the default sender email. If this isn’t set up, emails won’t go out.
• Test the schedule with a one-time run set to a few minutes in the future. This lets you verify the email arrives, the report is attached correctly, and the data in the report is as expected.
• If your report uses dynamic data (like date ranges), use relative parameters where possible (e.g., "Last Month" instead of a fixed date) so the schedule stays relevant without manual updates.

内容的提问来源于stack exchange，提问作者Swapnil Solanki