USP_DATAFORMTEMPLATE_VIEW_EMAILJOB_STATUS

The load procedure used by the view dataform template "Email Job Status View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PARAMETERID	uniqueidentifier	INOUT	Parameter id
@DATERUN	datetime	INOUT	Last run on
@NAME	nvarchar(20)	INOUT	Status job name

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_EMAILJOB_STATUS
        (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @PARAMETERID uniqueidentifier = null output,
            @DATERUN datetime = null output,
          @NAME nvarchar(20) = null output
        )
        as
            set nocount on;

            set @DATALOADED = 1; -- don't display warning with no data 


          select top 1
            @DATALOADED = 1,
            @PARAMETERID = ID, 
            @DATERUN = LASTRUNON,
            @NAME = NAME
          from GLOBALCHANGE where GLOBALCHANGECATALOGID = @ID order by LASTRUNON desc;


            return 0;