spUpdateStatusOnly_EmailJob

Parameters

Parameter	Parameter Type	Mode
@EmailID	int	IN
@EmailJobID	int	IN
@Status	tinyint	IN
@StatusText	nvarchar(32)	IN
@ErrorText	nvarchar(4000)	IN

Definition

Copy



CREATE PROCEDURE [dbo].[spUpdateStatusOnly_EmailJob]
(
    @EmailID int,
    @EmailJobID int,
    @Status tinyint,
    @StatusText nvarchar(32),
    @ErrorText nvarchar(4000)
)
AS
BEGIN
    DECLARE @hResult int  /* COM Variable-Naming Convention */
    SET @hResult = 0

    BEGIN TRANSACTION
    IF (@EmailJobID<=0) 
        BEGIN
            SET @hResult = -1
        END 
    ELSE 
        BEGIN
            UPDATE [dbo].EmailJob
            SET [Status]=@Status
            WHERE ID=@EmailJobID

            insert into [dbo].[EmailJobStatus] (EmailID, EmailJobID, Status, ErrorText)
            values(@EmailID, @EmailJobID, @StatusText, @ErrorText)

            IF (@@ERROR <> 0) SET @hResult = @@ERROR
        END
    COMMIT TRANSACTION
    RETURN @hResult
END