USP_GET_SQLJOB_SCHEDULES

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSPROCESSID	uniqueidentifier	IN
Definition

Copy


create procedure dbo.USP_GET_SQLJOB_SCHEDULES    (@BUSINESSPROCESSID as uniqueidentifier = null)
as
begin
    select 
        BUSINESSPROCESSID
        ,JOBNAME
        ,DESCRIPTION
        ,SCHEDULEFREQUENCYTYPE
        ,SCHEDULEONCEDATE
        ,SCHEDULEONCETIME
        ,SCHEDULEFREQUENCYMONTHLYINTERVAL
        ,SCHEDULEFREQUENCYEVERY
        ,SCHEDULEFREQUENCYINTERVAL
        ,SCHEDULEWEEKLYMONDAY
        ,SCHEDULEWEEKLYTUESDAY
        ,SCHEDULEWEEKLYWEDNESDAY
        ,SCHEDULEWEEKLYTHURSDAY
        ,SCHEDULEWEEKLYFRIDAY
        ,SCHEDULEWEEKLYSATURDAY
        ,SCHEDULEWEEKLYSUNDAY
        ,SCHEDULEFREQUENCYMONTHLYISRELATIVE
        ,ENABLESCHEDULE
        ,SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL
        ,SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY
        ,SCHEDULEFREQUENCYSUBDAYTYPE
        ,SCHEDULEFREQUENCYSUBDAYISRELATIVE
        ,SCHEDULEFREQUENCYSUBDAYINTERVAL
        ,SCHEDULEACTIVESTARTTIME
        ,SCHEDULEACTIVEENDTIME
        ,SCHEDULEACTIVESTARTDATE
        ,SCHEDULEACTIVEENDDATE
        ,SCHEDULENOENDDATE
        ,RECORDID
        ,ONHEARTBEAT
    from dbo.CMSSQLJOBSCHEDULES where      @BUSINESSPROCESSID is null or BUSINESSPROCESSID = @BUSINESSPROCESSID
end