Custom SQL Commands: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
mNo edit summary
Khm (talk | contribs)
No edit summary
Line 1: Line 1:
Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.
Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.


This feature is found here: Configurator -> Settings -> Custom SQL Commands<br />
This feature is found here: Configurator -> Settings -> Custom SQL Commands
 
 
If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.
 
<br />


==Jobs==
==Jobs==

Revision as of 08:57, 16 January 2019

Custom SQL Commands are a feature for executing customized SQL at specific moments in various background jobs. This moment depends on the job you attach the SQL command to.

This feature is found here: Configurator -> Settings -> Custom SQL Commands


If you ever want to use the UNILOGIN column, you'll need to run it after SLI - use the checkbox to change from before to after.


Jobs

The following is a list of all programs you can attach Custom SQL commands to. Note that you will only see the programs you have licenses for. (GetStudents require no license)

GetStudents

GetTimetable

Moodle

Moodle Cohort

Canvas

Google Apps Drive Sync

Google Apps Sites Sync

Fronter

ELEARNINGFORCE

Export User Info to Admin systems

Office 365 SharePoint Sync

OneNote Class Notebook

SLI