USP_GET_SQLJOBS

create procedure dbo.USP_GET_SQLJOBS
    @DATABASENAME sysname
as
begin
    select 

    SJ.NAME,
    SS.[ENABLED],
    SS.FREQ_TYPE,
    SS.FREQ_INTERVAL,
    SS.FREQ_SUBDAY_TYPE,
    SS.FREQ_SUBDAY_INTERVAL,
    CAST(LEFT(RIGHT('000000' + CAST(SS.ACTIVE_START_TIME AS VARCHAR), 6), 2) + ':'
        + SUBSTRING(RIGHT('000000' + CAST(SS.ACTIVE_START_TIME AS VARCHAR), 6), 3, 2)
        + ':' + RIGHT(RIGHT('000000' + CAST(SS.ACTIVE_START_TIME AS VARCHAR), 6), 2) AS TIME) AS START_TIME
    from msdb.dbo.SYSSCHEDULES SS 
    inner join msdb.dbo.SYSJOBSCHEDULES SJS 
    on SS.SCHEDULE_ID=SJS.SCHEDULE_ID inner join msdb.dbo.SYSJOBS SJ ON SJS.JOB_ID=SJ.JOB_ID where SJ.NAME like '%' +  @DATABASENAME + '%' 
end