/****** Object:  Stored Procedure dbo.DELETE_UND_JOB    Script Date: 12/1/2005 11:49:12 PM ******/

/****** Object:  Stored Procedure DELETE_UND_JOB    Script Date: 3/25/2005 2:24:50 PM ******/
CREATE PROCEDURE [DELETE_UND_JOB]
    (@job_id_1     [bigint])

AS

UPDATE [srdb].[und_job]

SET [status] = 'deleted', [dt_last_modified] = getdate()

WHERE
    ( [job_id]     = @job_id_1)

UPDATE  [srdb].[und_task]

SET [status] = 'deleted', [dt_last_modified] = getdate()

WHERE
    ( [job_id]     = @job_id_1)
GO
GRANT EXECUTE ON  [dbo].[DELETE_UND_JOB] TO [uniadmin]
GRANT EXECUTE ON  [dbo].[DELETE_UND_JOB] TO [uniuser]
GO