| View Name: | MARIServiceJobSchedule |
| Based on table: | MPServiceJobSchedule |
| Group: | Group: ServiceJob |
| Description: | MARIService: Service Job timing |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ServiceJob | ServiceJob INT Primary |
MARIServiceJobs.ServiceJob | |
| ScheduleIndex | ScheduleIndex INT Primary |
||
| StartDate | StartDate Datetime Index |
||
| EndDate | EndDate Datetime |
||
| StartTime | StartTime Datetime |
||
| EndTime | EndTime Datetime |
||
| DurationMode | DurationMode INT |
||
| DurationValue | DurationValue INT |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| IntervalLength | IntervallLaenge INT |
||
| IntervalType | IntervallTyp INT |
1=once, 2=dayly, 3=weekly,4=monthly | |
| LastRun | LastRun Datetime |