Viewing and Scheduling Jobs
When you perform an operation in Strata, such as performing a filter operation, importing a table or opening a data table from the web it is logged in the Job Manager. The Job Manager gives you a history of most processes, including the time, the length and the status.
Viewing and Reviewing Jobs
For many types of jobs, such as filtering on a small data set, the operation will appear to run almost instantly. However, for each type of operation, a "job" is run, a job status appears in the status bar, and the job is recorded by the job manager.
In the example above, we are running a filter operation on this data table. It has approximately 600,000 records, so the operation takes a few seconds to process. The green progress bar in the status bar at the bottom shows approximately how much of the processing has been finished. To view more information, either double-click on the progress bar or select Job Manager from the Tools menu to open up the Job Manager. When jobs are in process, the Job Manager also shows the progress of the job with additional detail.
Once a job is finished, it is recorded in the Job Manager for review. You can clear all contents by clicking the Clean Up button on the bottom left. Jobs are given a green checkmark if they processed correctly or a red "x" if they did work properly. Strata processes all jobs in the background, so if you wish to run multiple jobs at one time, they will queue up in the Job Manager.
If you create a valid query or script, you can run them at a specified time in the future or on a recurring basis. This is often helpful if wish to run a certain process on a data set that is regularly updated with new data. For instance, in this situation, you could create a script that ran the desired operations and run it overnight, after the data had been refreshed. To schedule a job, select Schedule Jobs from the Tools menu.
On the left side of the dialog are the job names and schedule. You can edit the name of the job by double-clicking on the name. The Schedule will update depending on what schedule settings are selected on the right side of the dialog. To delete a job, select the job and then click the Delete key on your keyboard.
Jobs can be scheduled Once or on a Daily, Weekly or Monthly basis. This setting can be changed by selecting the Schedule Job drop-down menu on the top right side of the dialog:
On the bottom right side of the dialog is the Processes section, a place to add your queries or scripts for processing. Drag these operations from the project panel into this area. Jobs will run based on the order they are added to the Processes section. To delete a command, select the operation you wish to remove and click the Delete key from your keyboard.