[dbo].[ujo_avg_job

[dbo].[ujo_avg_job_runs]

(local) > mdb > Tables > dbo.ujo_avg_job_runs

Properties
Columns
Indexes
Permissions
SQL Script
Uses
Used By

Property	Value
Row Count	0
Created	11:13:12 AM Wednesday, March 07, 2007
Last Modified	11:13:12 AM Wednesday, March 07, 2007

Columns

Name	Data Type	Max Length (Bytes)
joid	int	4
avg_runtime	int	4
num_runs	int	4

Indexes

	Name	Columns	Unique
	avg_job_runs_PUC	joid

Permissions

Type	Action	Owning Principal
Grant	Delete	ujoadmin
Grant	Insert	ujoadmin
Grant	Select	ujoadmin
Grant	Update	ujoadmin

SQL Script

CREATE TABLE [dbo].[ujo_avg_job_runs]
(
[joid] [int] NOT NULL,
[avg_runtime] [int] NULL,
[num_runs] [int] NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [avg_job_runs_PUC] ON [dbo].[ujo_avg_job_runs] ([joid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_avg_job_runs] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_avg_job_runs] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_avg_job_runs] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_avg_job_runs] TO [ujoadmin]
GO

Uses

Used By

[dbo].[ujo_init_jobset]
[dbo].[ujo_put_jobrow]