Stored Procedures [dbo].[ADD_UND_JOB]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@user_id_1bigint8
@name_2nvarchar(75)150
@description_3nvarchar(200)400
@reoccurring_interval_4int4
Permissions
TypeActionOwning Principal
GrantExecuteuniadmin
GrantExecuteuniuser
SQL Script
/****** Object:  Stored Procedure dbo.ADD_UND_JOB    Script Date: 12/1/2005 11:49:11 PM ******/

/****** Object:  Stored Procedure ADD_UND_JOB    Script Date: 3/25/2005 2:24:50 PM ******/
CREATE PROCEDURE [ADD_UND_JOB]
    (@user_id_1     [bigint],
     @name_2     [nvarchar](75),
     @description_3     [nvarchar](200),
     @reoccurring_interval_4     [int])

AS INSERT INTO [srdb].[und_job]
     ( [user_id],
     [name],
     [description],
    [status],
     [reoccurring_interval],
    [dt_created],
    [dt_last_modified])

VALUES
    ( @user_id_1,
     @name_2,
     @description_3,
    'Created',
     @reoccurring_interval_4,
    getdate(),
    getdate())
GO
GRANT EXECUTE ON  [dbo].[ADD_UND_JOB] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[ADD_UND_JOB] TO [uniuser]
GO
Uses