Once a query gives you the answer you want, you can have it run by itself every morning, every hour or on any timetable you like, without leaving LumiCode. LumiCode creates the schedule in the LUSID Scheduler, so it runs whether or not LumiCode is open.
Prerequisites
LumiCode installed and signed in. See How do I install LumiCode?
The Luminesce Query Runner job (
default/QueryRunner) set up in your domain. If it isn't, LumiCode tells you, and your domain's administrator needs to install it.Permission to create schedules in the LUSID Scheduler.
The query you want to schedule, run at least once in LumiCode.
Method
Step 1: Pick the query
Type
/recentand press Enter.Select the query and press Enter.
Choose run it on a schedule.
If schedules already run the Luminesce Query Runner job, LumiCode lists them first. Choose a new schedule, or select an existing one to change it so it runs this query instead.
Step 2: Name the schedule
LumiCode asks for each of the following in turn, with a suggested answer you can accept with Enter:
Scope and code, which together identify the schedule. The scope defaults to
lumi.Name and description, shown in the Scheduler.
The user to run as. The schedule runs with this user's permissions. It defaults to you, and the Scheduler also accepts a service user.
Press Esc at any point to go back one question.
Step 3: Check the arguments
LumiCode lists the job's arguments, each set to the job's default, with your query as QUERY_01. Select an argument to change its value. When they're right, choose these arguments are right.
You can't edit the query itself here. To change it, edit and run it at the prompt, then schedule it again from /recent.
Step 4: Choose when it runs
Choose one of the following:
daily, at a time: enter a time of day, such as
07:30, then choose the days of the week.hourly, at a minute past the hour: enter the minute, then choose the days of the week.
a cron expression: for anything else. The Scheduler uses Quartz cron expressions, which start with seconds, for example
0 0 7 ? * *for 07:00 every day.
Then choose the time zone. UTC is first in the list.
Step 5: Confirm
LumiCode shows a summary of the schedule. Check it and confirm. LumiCode then shows the new schedule's identifier and when it runs.
Monitoring a schedule
Type /schedules to list the schedules that run the Luminesce Query Runner job. Select one to see its runs, newest first. A failed run shows why on its row. Select a run to open the Scheduler's log, save it to a file or copy the run ID.
/schedules is read-only. To pause or delete a schedule, use the Job Scheduler page in the LUSID web app.