Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The job scheduler performs a procedure according to the settings registered in the job object.

  • OBJOB_SCHEDULER_ENABLE : Task Scheduler Enable settings
  • JOB_THREAD_COUNT         : Number of threads to execute Job object

...

The stored procedure to be executed, execution time, and execution cycle can be set in the JOB object. For the statement of creating a JOB object, refer to the SQL Reference manual. (Manual download page: http://support.altibase.com/en/manual or https://github.com/ALTIBASE/Documents/tree/master/Manuals/Altibase_7.1/eng)

Code Block
languagesql
CREATE JOB job1
EXEC proc1
START sysdate
END sysdate + 3
INTERVAL 1 HOUR; 

...

Note
titleHow to check the error message corresponding to the error code

The error message corresponding to the error code can be checked by using the altierr utility.


$altierr 0x31129

0x31129 (201001) qpERR_ABORT_QSV_NOT_EXIST_PROC_SQLTEXT Procedure or function not found : <0%s>.
# *Cause: The specified procedure or function name was not found in the database.
# *Action: Verify that the procedure or function exists.

...