Post reply

Can I retrieve when a specific job schedule was last exectuted

  • February 14, 2023 at 2:52 pm

    #4149545

    Hi people;

    I haven't posted on here in a while since I switched careers but stumbled into a weird issue today with a database job.

    The issue is on SQL Server Management Studio (SSMS) 17.5 14.0.17224.0

    The job runs weekly on Sunday evening but was not executed on 12/02/2023.

    Job logging shows neither run or error.

    Is their a way to check if a specific schedule was executed or not.

     

    • This topic was modified 1 year, 10 months ago by  Resender.

  • February 14, 2023 at 3:18 pm

    #4149574

    Schedules aren't executed, it's the jobs that are, the schedule just denotes the time(s) that job runs. If you can't see that the job was executed at that time then, unless the logs have been purged, it wasn't. Why could be for several reasons, though the most obvious might be that the host was not on, perhaps an (un)scheduled restart, or the SQL Server (Agent) service wasn't running. If a job's schedule is missed, SQL Server won't automatically run any tasks that were missed.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • February 15, 2023 at 7:57 am

    #4149912

    OK, I will doublecheck whether the logs were purged (if possible).

    As far as I'm aware the system was up at the time.

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply