실행 이력 조회.

--마지막 실행 시간 조회
    SELECT
        name AS ProcedureName,
        last_execution_time AS LastExecutionTime,
cached_time
    FROM
        sys.procedures
    CROSS APPLY
        (SELECT MAX(last_execution_time) AS last_execution_time, MAX(cached_time) AS cached_time
         FROM sys.dm_exec_procedure_stats
         WHERE object_id = sys.procedures.object_id) AS execution_stats
    WHERE
        OBJECTPROPERTY(object_id, 'IsProcedure') = 1
--AND name LIKE '%MES_FI_PM_FI_R3MM_ROLL_SP%'
    ORDER BY
        last_execution_time DESC;



--실행 이력 조회. 

    SELECT
        DB_NAME(database_id) AS DatabaseName,
        OBJECT_SCHEMA_NAME(object_id, database_id) AS SchemaName,
        OBJECT_NAME(object_id, database_id) AS ProcedureName,
        execution_count AS ExecutionCount,
        total_elapsed_time AS TotalElapsedTime,
        last_execution_time AS LastExecutionTime
    FROM
        sys.dm_exec_procedure_stats
    WHERE
        database_id = DB_ID()
        AND OBJECT_ID(OBJECT_SCHEMA_NAME(object_id, database_id) + '.' + OBJECT_NAME(object_id, database_id)) IN (
            SELECT object_id
            FROM sys.objects
            WHERE type = 'P'
        )
    ORDER BY
        last_execution_time DESC;