• Try this,

    It will tell you the current status and last Execution and future execution times.

    USE [msdb]

    sp_help_job