CREATE TABLE [dbo].[linkjob]
(
[object_uuid] [binary] (16) NOT NULL,
[object_type] [int] NULL,
[object_domain_uuid] [binary] (16) NULL,
[jdomid] [int] NOT NULL,
[jobid] [int] NOT NULL,
[jostatus] [int] NULL,
[auto_rep_version] [timestamp] NULL
) ON [PRIMARY]
GO
CREATE trigger linkjob_agent_delete
    on linkjob for DELETE
as
BEGIN
    declare @object_uuid binary(16);
    
    DECLARE linkjob_ag_del_cur CURSOR
        FOR SELECT object_uuid
            FROM deleted
        
        OPEN linkjob_ag_del_cur
        FETCH NEXT FROM linkjob_ag_del_cur INTO @object_uuid
        WHILE @@FETCH_STATUS = 0
        BEGIN
            execute ca_agent_server_version_by_uuid @object_uuid;
        
            FETCH NEXT FROM linkjob_ag_del_cur INTO @object_uuid;
        END
        CLOSE linkjob_ag_del_cur
        DEALLOCATE linkjob_ag_del_cur
END
GO
/****** Object:  Trigger dbo.linkjob_agent_insert    Script Date: 12/1/2005 11:51:16 PM ******/

CREATE trigger linkjob_agent_insert
on linkjob
after insert
as
begin
declare @object_uuid binary(16);

DECLARE trans_Cursor CURSOR
FOR SELECT object_uuid
FROM inserted

OPEN trans_Cursor
FETCH NEXT FROM trans_Cursor INTO @object_uuid
WHILE @@FETCH_STATUS = 0
BEGIN
execute ca_agent_server_version_by_uuid @object_uuid;

FETCH NEXT FROM trans_Cursor INTO @object_uuid;
END
CLOSE trans_Cursor
DEALLOCATE trans_Cursor

end;
GO
/****** Object:  Trigger dbo.linkjob_agent_update    Script Date: 12/1/2005 11:51:16 PM ******/


/*
************************************
* after update(object_uuid,object_type,object_domain_uuid,JOBID,JDOMID,JOSTATUS)
*/


CREATE trigger linkjob_agent_update
   on linkjob
  after update
as
if update(object_uuid) or UPDATE(object_type) or UPDATE(object_domain_uuid) or
    UPDATE(JOBID) or UPDATE(JDOMID) or UPDATE(JOSTATUS)
begin
  
    declare @object_uuid binary(16);
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT object_uuid
            FROM inserted
        
        OPEN trans_Cursor
        FETCH NEXT FROM trans_Cursor INTO @object_uuid
        WHILE @@FETCH_STATUS = 0
        BEGIN
            execute ca_agent_server_version_by_uuid @object_uuid;
        
            FETCH NEXT FROM trans_Cursor INTO @object_uuid;
        END
        CLOSE trans_Cursor
        DEALLOCATE trans_Cursor
end;
GO
ALTER TABLE [dbo].[linkjob] ADD CONSTRAINT [XPKlinkjob] PRIMARY KEY CLUSTERED ([object_uuid], [jobid], [jdomid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [linkjob_sk1] ON [dbo].[linkjob] ([object_uuid], [object_domain_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[linkjob] TO [ams_group]
GRANT SELECT ON  [dbo].[linkjob] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[linkjob] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[linkjob] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[linkjob] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[linkjob] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[linkjob] TO [upmuser_group]
GO