MES Stateless API

DoHourlyTasks Method

Save PDF

Welcome to the MES Stateless API
Legal Information
Introduction to Stateless API Scripts in System Platform
Using the Stateless API
Fact.Common Assembly
- Overview
- Namespaces
FactMES.API.Commerce Assembly
- Overview
- Namespaces
  - FactMES.API.Commerce Namespace
FactMES.API.Core Assembly
- Overview
- Namespaces
  - FactMES.API.Core Namespace
FactMES.API.EnProd Assembly
- Overview
- Namespaces
  - FactMES.API.EnProd Namespace
FactMES.API.Labor Assembly
- Overview
- Namespaces
  - FactMES.API.Labor Namespace
    - Overview
    - Classes
FactMES.API.Prod Assembly
- Overview
- Namespaces
  - FactMES.API.Prod Namespace
FactMES.API.Quality Assembly
- Overview
- Namespaces
  - FactMES.API.Quality Namespace
FactMES.API.Util Assembly
- Overview
- Namespaces
  - FactMES.API.Util Namespace
Technical Support

Save PDF

The DoHourlyTasks() method performs hourly system maintenance.

'Declaration
 
Public Shared Sub DoHourlyTasks( _
   ByVal sessionId As Integer _
)

'Usage
 
Dim sessionId As Integer
 
Session.DoHourlyTasks(sessionId)

public static void DoHourlyTasks( 
   int sessionId
)

sessionId: Required. Holds the session ID and thus the user who is making this method call.

This method is called by the background service every hour. It performs the following:

Readies jobs (state_cd=2) if the release time of a work order is older than the current date and time, and the current state for a job is New (state_cd=1) and the job is the first job in the work order, and the system attribute Initial status of the first job in a work order (attr_id=310) is set to ready.
Reads the system attribute Archive database server name (attr_id=224) and Archive database name (attr_id=225) from system attributes, and calls a custom stored procedure sp_Archive_WO. This stored procedure has no functionality out of the box. The customer must supply the logic for this stored procedure.
For all jobs that are currently running on the entities, an hourly bucket is created for each job in the Job_Hour_History table.
For all jobs that ran 3 hours before the current UTC time, the statistics (runtime, downtime, idletime, qty_good, and qty_reject) are updated in the Job_Hour_History table.

Initial status of the first job in a work orderArchive database server nameArchive database name

Initial status of the first job in a work orderArchive database server nameArchive database name