SQL
SQL Query Tool lets you extract information from your database. SQL knowledge required.
Microsoft Query and View Designer Considerations Link.
- Enter your query statement in the box.
- Click on Execute.
- Your report will open in a new window.
You have now queried your database.
Schedule
The schedule allows you to add third party modules that can automatically execute tasks at a defined time. You can also control seven built-in DotNetNuke management processes.
- Click on Schedule. You will now see a list of processes and their schedule currently running. Click on the pencil icon beside each process to edit schedule.
- Mouse over the pencil icon beside Schedule
- Click on View Schedule Status - Displays the current status of items in a queue of running processes and lets you Start/Stop them.
- Click on View Schedule History - Displays a detailed record of all the execution events.
- Add Item to Schedule - Opens the Edit Schedule screen and allows you to configure the tasks.
Tasks
|
Available Tasks: |
From the dropdown list highlight and select the task you want to change. |
|
Schedule Enabled Checkbox: |
Click the Schedule Enabled box to enable the event. |
|
Time Lapse: |
From the dropdown list choose the frequency that you want your process to execute on. |
|
Retry Frequency: |
From the dropdown list choose the number of minutes to wait before retrying the task after a failure. |
|
Retain Schedule History: |
From the dropdown list choose the number of individual records you wish to keep in the events history file. |
|
Run On Events: |
For custom modules that need configuring, follow your module instructions. This setting allows your module developer to trigger the process required. |
|
Catch Up Enabled: |
Click the checkbox to let the web server automatically process events that were missed in case of server shutdown. |
|
Object Dependencies: |
Check with your module developers’ documentation to obtain the correct setting. This field is used to prevent multiple processes from causing a conflict with one another as they perform their functions. |
- Click on Save to save any settings you have added or changed.
For more information read the document in /Portals/Documentation/DotNetNuke Scheduler Word Document by Dan Caron. You can also download a copy from http://www.dotnetnuke.com.
You have now completed the Host Menu Tab and SQL and Schedule.