CREATE TABLE [dbo].[joborder]
(
[udomid] [int] NOT NULL,
[unitid] [int] NOT NULL,
[jdomid] [int] NOT NULL,
[jobid] [int] NOT NULL,
[joorder] [int] NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE trigger joborder_agent_delete
  on joborder
  for delete

as
begin
    declare @domainid int,@unitid int ;
    
    DECLARE jobor_ag_del_cur CURSOR
        FOR SELECT udomid,unitid
            FROM deleted
            
    OPEN jobor_ag_del_cur
    FETCH NEXT FROM jobor_ag_del_cur INTO @domainid,@unitid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_unit @domainid,@unitid
        FETCH NEXT FROM jobor_ag_del_cur INTO @domainid,@unitid
    END
    CLOSE jobor_ag_del_cur
    DEALLOCATE jobor_ag_del_cur
  
      
end
GO
/****** Object:  Trigger dbo.joborder_agent_insert    Script Date: 12/1/2005 11:51:14 PM ******/

/*
************************************
*
*/

CREATE trigger joborder_agent_insert
   on joborder
   after insert
as
begin
    declare @domainid int;
    declare @unitid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT udomid,unitid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@unitid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_unit @domainid,@unitid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@unitid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
   
      
end;
GO
/****** Object:  Trigger dbo.joborder_agent_update    Script Date: 12/1/2005 11:51:15 PM ******/

/*
************************************
* after update(UNITID,JOBID,UDOMID,JDOMID,JOORDER)
*/

CREATE trigger joborder_agent_update
    on joborder
    after update
    

as
if update(UNITID) or UPDATE(JOBID) or UPDATE(UDOMID) or UPDATE(JDOMID) or UPDATE(JOORDER)
begin
    declare @domainid int,@unitid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT udomid,unitid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@unitid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ca_agent_server_version_by_unit @domainid,@unitid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@unitid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
ALTER TABLE [dbo].[joborder] ADD CONSTRAINT [XPKjoborder] PRIMARY KEY CLUSTERED ([unitid], [jobid], [udomid], [jdomid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [joborder_sk2] ON [dbo].[joborder] ([jobid], [unitid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [joborder_sk1] ON [dbo].[joborder] ([unitid], [udomid]) WITH (FILLFACTOR=90) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[joborder] TO [ams_group]
GRANT SELECT ON  [dbo].[joborder] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[joborder] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[joborder] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[joborder] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[joborder] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[joborder] TO [upmuser_group]
GO