Create DBMS Jobs - Intergraph Smart Reference Data - 2020 (10.0) - Help - Hexagon

Intergraph Smart Reference Data Plus Help (2020)
Language
English
Product
Intergraph Smart Reference Data
Search by Category
Help
Smart Materials/Smart Reference Data Version
2020 (10.0)

  1. From the Home screen, select Administration > Global Setup > DBMS Jobs.

  2. Click Create New Job.

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

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

  5. Select a start date for the job.

  6. Type a SQL query in Executed Statement cell to execute when the DBMS job is run.

  7. 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 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.