USP_EMAILJOB_ADDTEMPORARYMETADATA

CREATE procedure dbo.USP_EMAILJOB_ADDTEMPORARYMETADATA
(
    @EMAILJOBID int = null,
    @TABLENAME nvarchar(255) = ''
)
as
begin

    declare @ID uniqueidentifier = newid()

    declare @CHANGEAGENTID uniqueidentifier
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        -- handle inserting the data but not if its already been linked.

        if not exists (select 1 from dbo.EMAILJOBTEMPORARYMETATDATA where EMAILJOBID = @EMAILJOBID and TABLENAME = @TABLENAME)            
            insert into dbo.EMAILJOBTEMPORARYMETATDATA
                (ID, EMAILJOBID, TABLENAME, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
                (@ID, @EMAILJOBID, @TABLENAME, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)    
    end try

    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

end