BankPoint includes an integrated job scheduling service which allows you to execute BankPoint commands on a recurring basis.
BankPoint includes a number of pre-defined commands for activities such as daily import processing, email notifications, or sending out reports.
Covered in this article:
Configuring a Job
To add a new BankPoint job, first go to the Jobs screen by selecting "Jobs" under the Tools menu option. From the Jobs screen, click on Actions and select "New Job". Or click on the edit icon next to the job you want to edit it.
On the Edit Job screen, populate the fields to create a new BankPoint Job as follows:
Name: The name or short description of the new job.
Disabled: Check this only if you would like the job to be configured but not run.
Send Notifications: Check this only if you would like e-mail notifications to be sent out when the job is executed.
Execution Mode: Select the type of job. Values are Not Scheduled for jobs that run on demand, Scheduled for jobs that run on a specific schedule, and Run Continuously for jobs that need to run 24/7 at a specific interval.
Cron Trigger: If the selected Execution Mode is Scheduled, then a box will be displayed to enter the Cron Trigger schedule. Cron Trigger tutorial and examples can be found here.
Seconds Between Loop: If the selected Execution Mode is 'Run Continuously', a box will be displayed to enter the number of seconds between every run. This field should be populated with a number that defines the number of seconds. For example: 15, 120, 360, etc.
Steps: Enter here the steps to be executed. A few examples are ArcsLink to run an import, Transfer to populate the data warehouse with the last import's data, or DeliverSummaryReports to send e-mail with scheduled Summary Reports
Click on the Add step link to add a new row for additional steps.
On this screen, steps can also be ordered by clicking on the icon left of the step, dragging and dropping steps around the screen to the desired position. The ordering here controls how steps are executed.
Click Save at the bottom of the screen to save the changes.
Job Configuration Examples
Below are sample job configurations:
1: Non-processing days job that runs Transfer (which pushes latest information to data warehouse and reports) at 6 AM every Sunday and Monday.
2: A Ping job that continuously pings the BankPoint web application to ensure that it stays active and resident in memory.
3: A Daily data update job that processes files from three different source systems and then runs Transfer. Finally, an e-mail notification is sent when the job is completed.
Running a Job
Step 1: On the Jobs screen, make sure the BankPoint Service is running
Step 2: Click on the link with the job name to open the selected job screen
Step 4: On the job screen, click on Actions and select "Execute Job".
Step 5: On the Execute Job screen you can adjust some of the job parameters if needed. For example, you can choose to only run a few of the commands or run one of the commands with a different argument, say a different effective day.
Click on "Execute" to start the job.
Reviewing the Job Log
When a BankPoint job runs, the execution log is recorded in the database and displayed on the job detailed screen.
System Administrators can then drill down on a specific run to see more information about the failure or success of each run.
The log can be useful for troubleshooting failures or confirming that email notifications have been sent to end users. The log timestamps will also give you an idea of how long it's taking for commands to run.