CREATE TABLE [dbo].[RunningJobs]
(
[JobID] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[StartDate] [datetime] NOT NULL,
[ComputerName] [nvarchar] (32) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[RequestName] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[RequestPath] [nvarchar] (425) COLLATE Latin1_General_CI_AS_KS_WS NOT NULL,
[UserId] [uniqueidentifier] NOT NULL,
[Description] [ntext] COLLATE Latin1_General_CI_AS_KS_WS NULL,
[Timeout] [int] NOT NULL,
[JobAction] [smallint] NOT NULL,
[JobType] [smallint] NOT NULL,
[JobStatus] [smallint] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[RunningJobs] ADD CONSTRAINT [PK_RunningJobs] PRIMARY KEY CLUSTERED ([JobID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_RunningJobsStatus] ON [dbo].[RunningJobs] ([ComputerName], [JobType]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[RunningJobs] TO [RSExecRole]
GRANT SELECT ON  [dbo].[RunningJobs] TO [RSExecRole]
GRANT INSERT ON  [dbo].[RunningJobs] TO [RSExecRole]
GRANT DELETE ON  [dbo].[RunningJobs] TO [RSExecRole]
GRANT UPDATE ON  [dbo].[RunningJobs] TO [RSExecRole]
GO