Information for the ServiceJob

Columns

• Id (datatype: int) Required Primary Key
• IsSystem (datatype: bit) Required Primary Key
• IsActive (datatype: bit) Required Primary Key
• Name (datatype: nvarchar(100)) Required Primary Key
• Description (datatype: nvarchar(max)) Required Primary Key
• Assembly (datatype: nvarchar(260)) Required Primary Key
• Class (datatype: nvarchar(100)) Required Primary Key
• CronExpression (datatype: nvarchar(120)) Required Primary Key
• LastSuccessfulRunDateTime (datatype: datetime) Required Primary Key
• LastRunDateTime (datatype: datetime) Required Primary Key
• LastRunDurationSeconds (datatype: int) Required Primary Key
• LastStatus (datatype: nvarchar(50)) Required Primary Key
• LastStatusMessage (datatype: nvarchar(max)) Required Primary Key
• LastRunSchedulerName (datatype: nvarchar(40)) Required Primary Key
• NotificationEmails (datatype: nvarchar(1000)) Required Primary Key
• NotificationStatus (datatype: int) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• EnableHistory (datatype: bit) Required Primary Key
• HistoryCount (datatype: int) Required Primary Key