Job Templates
The Job Template design lets you specify a Job, consisting of one or more steps, to be performed by the Processing Services service in Bizview. Using the Job Templates, you can start Reports, open Forms and save values, and execute Stored Procedures on demand by letting users start these Job(s), or scheduled using the Job Schedule feature. For instance, one common implementation is to have a Job fetching the Object Values from the ERP system. This Job can then be triggered by the users whenever they need to.
The main advantages in using Bizview Processing Services are:
You can define several steps in one Job and they can be vastly different.
You can empower users to actually run them simply by giving Users and/or Roles access to the Job in My Home Panel.
Users (and Superusers) that design these jobs do not have to have access to the database instance, nor do they have to have SQL Server Management Studio and Job agent installed.
This topic contains the following sections:
Creating a Job
Access Job Templates by selecting System Administration > Processing Services > Job Templates.
To create a new Job Template, select the Create a new job link.
Below is a list of Job fields:
Field | Description | Example | Note |
|---|---|---|---|
Job ID* | The unique ID for the Job. | ERPLOAD | Keep short, no spaces, no strange characters or numbers. |
Description* | The name that will be visible in dialogs and as logged on user. | Full ERP data refresh | |
Category | Select which category the Job belongs to. | ||
Selection Pane | Connect a Selection Pane to the Job. |
Once the Job is created you can start defining what should be done when running the Job.
Job Template Definition
Open the Job from Job Template list. You will see two tabs, Job Param and Job Steps.
Job Param
Use the Job Param tab o define global parameters to sent to and used by Stored Procedures when executing.
If a Job Param parameter is specified, but the stored procedure does not have that parameter, the procedure will execute without it.
If a Job Param parameter is specified and the same (exact name) is specified on the specific Job Step, the latter will be used.
The names of the parameters need to be exactly the same as the parameters in the stored procedure.
Below is a list of Job Param fields:
Field | Description | Example | Note |
|---|---|---|---|
Parameter name* | @<name of parameter> | @client_id | The name needs to be exactly same as the Stored Procedure parameter. If not, it will be ignored. |
Value* | The value to be sent to the parameter. | $CLIENT | As the value to be sent, you can use hard coded value (e.g. 10), Bizview variables (e.g. $CLIENT), or Selection Pane Control Tags (e.g. $FROMDATE). |
Job Steps
Use the Job Steps tab to specify what actions are to be performed, and in which order. Here, you add all these steps you want to be included in the Job.
Below is a list of Job Step fields:
Field | Description | Example | Note |
|---|---|---|---|
Step description* | Description of the Job Step. | 10. Load Object Data | Informative to add sequence number to description. |
Seq no | Execution Sequence Number. | 10 | Sequence number defines the order of execution. |
Step Type* | Select type of action to be performed. | Execute Stored Procedure | Options include: Execute Stored Procedure, Generate Form and Update Values, and |
Step Object* | Select step object to be processed . | stg.p_update_object_values | Dependent on Step Type. |
Specific Step Parameters | See Job Param definition above. | Each step can send individual parameters to the Step Object being performed. If same as Job Param, this definition will be used. |
Additional Information
Installing the Service Processing Services
Before any Jobs can be executed or run, the Bizview service Processing Services needs to be configured and started. For more information, see Bizview Processing Services in the Installation Document.
Usage
The Job Template design lets you specify a Job, consisting of one or more steps, to be performed by the Processing Services service in Bizview. Using the Job Templates, you can start Reports, open Forms and save values, and execute Stored Procedures.