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.

...

When using the Reporting Activity, instead of running the Report onto the screen, you can also choose to save the Report in the Document Library Activity.

Creating the Report


Opening Reporting Activity

Click on Reporting Activity


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

Image Modified 

Details

Name - rename the report

Description - add a description

Click Next

Image Modified

Report Configuration

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

Click Next

Report output 

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

Choose the output

Click Next

 Image Removed

...

Choose from the options:

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

Adjust date relative to execution time - adjusts the date in the Report Configuration tab by the pattern in the Recurrence tab, ie by 1 day, 1 month etc.

OR

Dynamically set the date to X before execution time - this ignores the dates in the Report Configuration tab and uses the pattern in the Recurrence tab, and the date in the Activation 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

...

Same options as the End date tab

Click Next

...

The date and time you want to start the Scheduler

Tip: Amend the time to out of hours

Click Next

Image Removed

...

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

Click Next

Image Removed

...

Choose the run time(s) of the Schedule

Click Next

Image Removed

Image Removed

Image Removed

...

Choose when you want to cease the Schedule or choose Never

Click OK

Image Removed

Scheduler Activity Window

Here you can view and manage your current scheduled tasks.

Opening the Schedule Management Activity

Click on Schedule Management Activity

Image Removed

Image Removed

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

Scheduler Log – this section details the current status of the Scheduler system. Any problems or warnings will be highlighted in either red or yellow. You can access the full scheduler logs via the Sigma Service

Running Schedules – this section will show any scheduled tasks that are currently running on your system. It will also highlight if the Sigma Service cannot be foundChoose the Output type:

  • PDF
  • Excel
  • Word

 Image Added


Click OK

There is no need to go through the remainder of the screen - these are used if you are to schedule a Report.  Click here for more details on scheduling Reports. 


The Report will now be saved in the Document Library Activity.

Image Added