DBMS Jobs - Intergraph Smart Materials - 10.2 - Training - Hexagon

Smart Materials Web Tutorials

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Training
Smart Materials/Smart Reference Data Version
10.2

Create DBMS Jobs

  1. From the Home screen, select Administration > Global Setup > DBMS Jobs, and click Create Job.

  2. Type the DBMS job code and add a comment.

  3. Select an interval for execution of the job from the Interval list.

  4. Select a start date for the job.

  5. Type a SQL query in Executed Statement cell to execute when the DBMS job is run, and then click Create.

View or edit a DBMS job details

  1. From the DBMS Jobs screen, select a job.

  2. Type the changes to the SQL query in the Executed Statement cell in the Parameters section.

  3. Select Broken in the Parameters section to specify that the DBMS job/SQL query is broken and that the automatic job execution is disabled.

  4. To run the DBMS job, click Run Now.

  5. To set up a new Oracle job process, click Install.

  6. To view the log file associated with the DBMS job, click the file name in the Log Files block.