JOBS.AVALOQAGENT.RESETJOBS

As an administrator, after installing and configuring the Avaloq Agent, you must prepare the Avaloq database so that it can work with the Automation Engine.

The internal Avaloq scheduler executes jobs based on the reschedule intervals that are specified in each Avaloq job definition. If an Avaloq job definition does not contain a reschedule interval, the job is deleted one hour after it has been executed. To be able to use the Automation Engine as external scheduler, you must deactivate this function. Otherwise, there could be a conflict between the Avaloq internal scheduler and the Automation Engine. Deactivation means to move the reschedule intervals into the future. The recommended value is 13 months (+13m).

For this purpose, you create and execute JOBS.AVALOQAGENT.RESETJOB jobs. These jobs execute an SQL command on the Avaloq database that adjusts the reschedule interval and the End-Of-Day behavior for a specific Avaloq Business Unit. In addition, the Avaloq Agent sets the status of jobs to holding after their execution.

Important!

Executing this job once after installing the Avaloq Agent is a mandatory prerequisite to avoid conflicts when the Automation Engine takes over automation operations on Avaloq.
The Avaloq jobs that will be affected by this job MUST NOT BE RUNNING when you execute it. Make sure that you stop any background process that might trigger such Avaloq jobs before executing a JOBS.AVALOQAGENT.RESETJOB job.

To Create a JOBS.AVALOQAGENT.RESETDEPENDENCY Job

You create jobs in the Explorer list in the Process Assembly perspective.

Do one of the following:
- Click the Add Object button in the toolbar
- Right-click anywhere in the list and select Add Object.
On the Add Object dialog, do one of the following:
- In the Search field, start typing the type of object you want to create.
- Expand Job (JOBS) > AVALOQAGENT and select the type of job that you want to create.
Click the Add button. The Object Name dialog is displayed.
Enter a descriptive Name. Optionally, enter a short and descriptive Title that helps you recognize the purpose of the object.
Click OK.

The Avaloq job is created and available in the Explorer list and a new page opens to the Reset Jobs tab.
In Connection Settings > Avaloq Instance select the Connection object that will establish the communication between the Automation Engine and your Avaloq system.
In the Reset Jobs section
1. Reschedule Duration
  
  Time period that you move the reschedule interval into the future.
  
  Recommended value: +13m
  
  Possible values: +##[d|m|y]
2. End of Day Behavior
  
  Specify what should happen if the job is still executing at the EOD:
  - Complete before a date switch
    
    The date switch waits until the job completes.
    
    Important! Make sure that you monitor jobs with this setting accordingly. Jobs with very long execution times could block the Bank Date Switch.
  - Restart after a date switch
    
    This is the Avaloq default. the job stops immediately before EOD and resumes afterward.
    
    Important! We strongly recommend NOT TO USE this setting with an external scheduler (such as the Automation Engine), as it could lead to unpredictable conflicts.
  - Continue on start of End Of Day
    
    The job continues executing even if it has reached the EOD.
    
    Important! This setting can lead to conflicts between the jobs and the EOD. To avoid them, make sure that the behavior of the jobs is properly tested.
Go to the Attributes page. In the Execution Settings section, select the corresponding Avaloq Agent.
Go to the Rapid Automation tab to configure the job reporting options. For more information, see Job Reports and Optional Reports.