CREATE TABLE [dbo].[ncjobcfg]
(
[domainid] [int] NOT NULL,
[jobid] [int] NOT NULL,
[joname] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[jotype] [int] NULL,
[jocont] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jocmd] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[joos] [int] NULL,
[jocreate] [int] NULL,
[jomodify] [int] NULL,
[josdate] [int] NULL,
[jostime] [int] NULL,
[joedate] [int] NULL,
[joetime] [int] NULL,
[jofreq] [int] NULL,
[josched] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[joinst] [int] NULL,
[joonceat] [int] NULL,
[jooncenr] [int] NULL,
[joflag] [int] NULL,
[joexit] [int] NULL,
[jddomid] [int] NULL,
[jodepend] [int] NULL,
[joquest] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[joqforce] [int] NULL,
[joqfdate] [int] NULL,
[jologoff] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[joremove] [int] NULL,
[jodepfil] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jodevice] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[joserv] [nvarchar] (127) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[jodiscon] [int] NULL,
[joiconid] [int] NULL,
[jopartnr] [int] NULL,
[revnr] [int] NULL,
[userid] [int] NULL,
[checksum] [int] NULL,
[auto_server_version] [int] NULL CONSTRAINT [DF__ncjobcfg__auto_s__5A45429A] DEFAULT ((0)),
[auto_rep_version] [timestamp] NULL,
[job_uuid] [binary] (16) NULL,
[job_category] [int] NULL,
[creation_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_update_date] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Trigger dbo.ncjobcfg_update    Script Date: 12/1/2005 11:50:48 PM ******/


/*
************************************
* after update(JOBID,DOMAINID,JONAME,JOTYPE,JOCONT,JOCMD,JOOS,JOCREATE,JOMODIFY,JOSDATE,JOSTIME,
*
* JOEDATE,JOETIME,JOFREQ,JOSCHED,JOINST,JOONCEAT,JOONCENR,JOFLAG,JOEXIT,JDDOMID,JODEPEND,JOQUEST,
* JOQFORCE,JOQFDATE,JOLOGOFF,JOREMOVE,JODEPFIL,JODEVICE,JOSERV,JODISCON,JOICONID,JOPARTNR,REVNR,USERID,CHECKSUM)
*
*/
CREATE trigger ncjobcfg_update
  on ncjobcfg
  after update
  
as
if update(JOBID) or UPDATE(DOMAINID) or UPDATE(JONAME) or UPDATE(JOTYPE) or UPDATE(JOCONT) or
    UPDATE(JOCMD) or UPDATE(JOOS) or UPDATE(JOCREATE) or UPDATE(JOMODIFY) or UPDATE(JOSDATE) or
    UPDATE(JOSTIME) or UPDATE(JOEDATE) or UPDATE(JOETIME) or UPDATE(JOFREQ) or UPDATE(JOSCHED) or
    UPDATE(JOINST) or UPDATE(JOONCEAT) or UPDATE(JOONCENR) or UPDATE(JOFLAG) or UPDATE(JOEXIT) or
    UPDATE(JDDOMID) or UPDATE(JODEPEND) or UPDATE(JOQUEST) or UPDATE(JOQFORCE) or UPDATE(JOQFDATE) or
    UPDATE(JOLOGOFF) or UPDATE(JOREMOVE) or UPDATE(JODEPFIL) or UPDATE(JODEVICE) or UPDATE(JOSERV) or
    UPDATE(JODISCON) or UPDATE(JOICONID) or UPDATE(JOPARTNR) or UPDATE(REVNR) or UPDATE(USERID) or
    UPDATE(CHECKSUM)
begin
    declare @domainid int,@jobid int ;
    
    DECLARE trans_Cursor CURSOR
        FOR SELECT domainid,jobid
            FROM inserted
            
    OPEN trans_Cursor
    FETCH NEXT FROM trans_Cursor INTO @domainid,@jobid
    WHILE @@FETCH_STATUS = 0
    BEGIN
        execute ncjobcfg_server_version @domainid,@jobid
        FETCH NEXT FROM trans_Cursor INTO @domainid,@jobid
    END
    CLOSE trans_Cursor
    DEALLOCATE trans_Cursor
    
      
end
GO
/****** Object:  Trigger dbo.rule_d_so_del_job    Script Date: 12/1/2005 11:50:51 PM ******/

/*
*********************************************
trigger for deleting a job
*/
CREATE trigger rule_d_so_del_job
     on ncjobcfg
     after delete
as
begin
    declare @ddis_hw_uuid binary(16);


    DECLARE mycur CURSOR
        FOR select job_uuid from deleted

    OPEN mycur
    FETCH NEXT FROM mycur INTO @ddis_hw_uuid
    WHILE @@FETCH_STATUS = 0
    BEGIN

        execute   proc_d_so_removed_object @ddis_hw_uuid
        FETCH NEXT FROM mycur INTO @ddis_hw_uuid;

    END

    CLOSE mycur
    DEALLOCATE mycur

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


/*
*********************************************
trigger for creating jobs
*/


CREATE trigger rule_i_so_new_job
    on  ncjobcfg
    after insert
as
begin
    declare @_obj_uuid binary(16);
    declare @_uri nvarchar(255);
    declare @_job_category integer;


    select @_obj_uuid = (select job_uuid from inserted);
    select @_uri = (select creation_user from inserted);
    select @_job_category = (select job_category from inserted);


    execute  proc_i_so_new_job     @_obj_uuid, @_uri, @_job_category;
    
end;
GO
ALTER TABLE [dbo].[ncjobcfg] ADD CONSTRAINT [XPKncjobcfg] PRIMARY KEY CLUSTERED ([jobid], [domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncjobcfg_idx_01] ON [dbo].[ncjobcfg] ([job_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ncjobcfg_sk1] ON [dbo].[ncjobcfg] ([joflag]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ncjobcfg] TO [ams_group]
GRANT SELECT ON  [dbo].[ncjobcfg] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[ncjobcfg] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[ncjobcfg] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[ncjobcfg] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ncjobcfg] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[ncjobcfg] TO [upmuser_group]
GO