Viewing and Scheduling Jobs

In addition to reviewing historical jobs, two specific processes can be scheduled to run in the future: queries and scripts. This section will discuss both viewing and scheduling 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:

•

Daily: This will run the job once per day. Set your beginning time and date. If you want to stop the daily job at some point in the future, select and ending time and date. For perpetually recurring jobs, just make sure the End checkbox is not selected. Lastly, you can schedule the job to run multiple times per day, by repeating the job at a regular interval. Select the "Repeat every xx Minutes" and use the arrows to change the minute interval.

•

Weekly: This will run the job once per week or on set days per week. Set the beginning time and date. If you want to stop the weekly job at some point in the future, select an ending time and date. For perpetually recurring jobs, just make sure the End checkbox is not selected. Finally, select the weekday(s) you wish to run this job.

•

Monthly: This will run the job on a monthly basis. Set the beginning time and date. If you want to stop the monthly job at some point in the future, select and ending time and date. For perpetually recurring jobs, just make sure the End checkbox is not selected. Lastly, choose the day of the month you wish to schedule the job. It is recommended that you select only the 1st through 28th of any given month in order to make sure all months are accounted for (e.g., June does not have a 31st day).

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.