Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Scheduler activity shows an overview of your scheduled reports. The Activity is linked to the Sigma Service which is responsible for running the schedules.

Setting up Schedules - Reports


Opening Reporting Activity

Click on Reporting Activity

...

Create your report as normal, but instead of clicking the Run Report button, click on 

Image RemovedImage Added 

Details

Name - rename the report.  Best practice is to precede the name of the report with REPORT (so that it can be easily seen in the Schedule Management Activity

Description - add a description

Click Next

Image RemovedImage Added

Report Configuration

This tab will display what you chose to run the report on 

Click Next

Image RemovedImage Added

Report output 

Enter the To, From and Reply email addresses and the Subject

Choose the output

Click Next

 Image RemovedImage Added


End date

Choose from the options:

Always use the specified date – uses the date specified in the Report Configuration tab.

...

Dynamically select X before execution time - this takes the date in the Activation tab and moves it by X. This is most useful for monthly reports where the above option will not always be accurate. This option will select the end of the selected month (or the beginning if choosing the Start date)

Click Next

Image RemovedImage Added

Start date

Same options as the End date tab

Click Next


Activation

The date and time you want to start the Scheduler

Tip: Amend the time to out of hours

Click Next

Image RemovedImage Added


Recurrence

Choose how often you want to run the Report - for example Daily, Weekly or Monthly

Click Next

Image RemovedImage Added


Run time(s)

Choose the run time(s) of the Schedule

Click Next

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added



Schedule end

Choose when you want to cease the Schedule or choose Never

Click OK

Image RemovedImage Added



Scheduler Activity Window

Here you can view and manage your current scheduled tasks.

Opening the Schedule Management Activity

Click on Schedule Management Activity


Image RemovedImage Added


Schedule List – this section shows all current schedules within your database. Right-clicking on these will give you the following options: Edit, Remove or Run Now

...