Logo CRM database 'inde otomatik görev tamamlama alt yapısını oluşturmak için nesne bazında MT_Automatic_Task ve MT_Automatic_Task_Log nesneleri (Business Object) oluşturulmuştur.
- MT_Automatic_Task Nesnesinin Oluşturulması (BO)
Column_name | Type | Length | Nullable | Oid | uniqueidentifier | 16 | no | TaskType | SmallInt | 2 | no (ExchangeRateUpdate:0, Maintance:1, Report:2) | TaskName | nvarchar | 300 | no | TaskSchedule | nvarchar | max | no (json string) | TaskParameter | nvarchar | max | no (json string) | TaskScheduleSummary | nvarchar | 300 | no | WarningNotification | nvarchar | 500 | yes | TaskStatus | SmallInt | 2 | no (Running:0, Done:1 , Failed: 2) | LastOperationStatus | SmallInt | 2 | no (OnProcess=0, Success:1, Failed: 2) | LastException | nvarchar | 2000 | yes | QuartzKey | nvarchar | 100 | yes | QuartzGroup | nvarchar | 100 | yes | QuartzTriggerKey | nvarchar | 100 | yes | _CreatedBy | uniqueidentifier | 16 | yes | _CreatedDateTime | datetime | 8 | yes | _LastModifiedBy | uniqueidentifier | 16 | yes | _LastModifiedDateTime | datetime | 8 | yes |
- MT_Automatic_Task_Log Nesnesinin Oluşturulması (BO)
Column_name | Type | Length | Nullable | Oid | uniqueidentifier | 16 | no | AutomaticTaskOid | uniqueidentifier | 16 | no | OperationStatus | SmallInt | 2 | no (OnProcess=0, Success:1, Failed: 2) | InnerException | nvarchar | Max | yes | _CreatedBy | uniqueidentifier | 16 | yes | _CreatedDateTime | datetime | 8 | yes | _LastModifiedBy | uniqueidentifier | 16 | yes | _LastModifiedDateTime | datetime | 8 | yes |
|