You can use the Job Scheduler page to create DBMS jobs and schedule the jobs to run according to the specified frequency and start date. Additionally, you can run DBMS jobs. The functionality of this page is similar to the A.60.45 DBMS Jobs page in Smart Materials Classic.
-
This is an interactive report.
-
Click
and select the column where you want to search, type the search criterion in the
Search box, and click Go to apply the search.
-
To change the number of displayed rows, select a value from the Rows list.
-
Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).
The fields shown in the Job Scheduler block are explained below.
-
Job Name: Name of the DBMS Job.
-
Job Description: Description of the DBMS Job.
-
Project: Project for which DBMS job is executed.
-
Executed PU: Program unit that will be executed for the DBMS job.
-
Start Date: Start date of the DBMS Job.
-
Frequency: Frequency at which the job is executed.
-
Current Status: Current schedule status of the job.
-
Next Run: Date and time when the job will run next.
-
Last Run: Date and time when the job ran last time.
-
Job Result: Previous job run result.
-
Active: This value indicates whether the job is active or inactive.
-
Email: This value indicates whether the automatic email should be sent when the job is executed.
-
Email Address: Email address(es) to whom the automatic job email notification should be sent.
-
Email Trigger: This indicates at what point the automatic email should be sent. Possible values are ALL, JOB_ERROR or JOB_SUCCESS.
-
Email Body: Content of the email body to be used for sending the email.
-
Log: Name of the log file which is generated for the last run of the job. This displays a link to the log file.
Click the LOG link to open a new dialog displaying the generated log file. You can enter a comma separated list of email addresses in the Email Address box, and then click Email Log to send an email with the log file to the addressees.
The buttons and their purposes are described below.
-
Create New Job: This button is used to create a new DBMS job in the Job Details window.
-
Run Now: By pressing this button, you can execute the DBMS job.
-
Install: Using this button installs the DBMS jobs into the database to schedule it as per the frequency specified.
-
Uninstall: Using this button uninstalls the DBMS jobs from the database.
To edit DBMS job details or delete a job, click the Edit 
button in the first column. This will populate the Job Details block with the data of the selected DBMS job, to edit or delete the job. To delete
the selected job, click Delete.
To create a new DBMS job, do the following:
-
Click Create New Job.
-
Type a unique name in the Job Name box.
-
Optionally, describe the job in the Job Description box.
-
In the Executed PU box, enter the program unit that needs to be executed for the DBMS job.
-
Optionally, select the project for which the DBMS job needs to be executed from the Project list. The list shows only projects to which you have access to. This is only used for creating the job.
-
Enter the DBMS job start date in the Start Date box. The start date is sed for scheduling the job.
-
If required, change the frequency from Daily to another value.
-
If the job should not be used, set Active to No.
-
Optionally, set Email Required to Yes if an automatic email should be sent when the job is executed.
-
If Email Required is set to Yes, type a valid email address or a comma separated list of email addresses in the Email Address box. The software sends an email notification to the address(es) when the job is executed, depending on the Email Trigger setting.
-
If Email Required is set to Yes, select a value from the Email Trigger list. This setting controls at what point the automatic email should be sent. Possible values are ALL, ERROR, or SUCCESS.
-
If Email Required is set to Yes, enter the content of the email body to be used for sending the email in the Email Body box.
-
Click Save.