Tables [dbo].[vwtasksBU]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:56 AM Thursday, March 21, 2019
Last Modified1:00:56 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
TaskIDint4
False
TaskNamevarchar(50)50
False
TaskClassvarchar(50)50
False
StartDatedatetime8
False
Dayssmallint2
False
Weekssmallint2
False
Monthssmallint2
False
EndDatedatetime8
True
Secondssmallint2
False
Minutessmallint2
False
Hourssmallint2
False
NextDatedatetime8
False
LastDatedatetime8
True
ExeCountint4
False
ExeMaxint4
False
Enabledbit1
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
timestamptimestamp8
True
DaysOfWeektinyint1
False
TaskTypeIDint4
True
AssignedEnginevarchar(128)128
True
TaskStatusvarchar(128)128
True
AssignedUservarchar(128)128
True
StatusDetailsvarchar(1024)1024
True
LastFailDatedatetime8
False
LastDayOfMonthsmallint2
False
CREATE TABLE [dbo].[vwtasksBU]
(
[TaskID] [int] NOT NULL,
[TaskName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TaskClass] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[StartDate] [datetime] NOT NULL,
[Days] [smallint] NOT NULL,
[Weeks] [smallint] NOT NULL,
[Months] [smallint] NOT NULL,
[EndDate] [datetime] NULL,
[Seconds] [smallint] NOT NULL,
[Minutes] [smallint] NOT NULL,
[Hours] [smallint] NOT NULL,
[NextDate] [datetime] NOT NULL,
[LastDate] [datetime] NULL,
[ExeCount] [int] NOT NULL,
[ExeMax] [int] NOT NULL,
[Enabled] [bit] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NULL,
[DaysOfWeek] [tinyint] NOT NULL,
[TaskTypeID] [int] NULL,
[AssignedEngine] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaskStatus] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AssignedUser] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusDetails] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastFailDate] [datetime] NOT NULL,
[LastDayOfMonth] [smallint] NOT NULL
) ON [PRIMARY]
GO