0

I have several dozen SQL Server jobs that the Job Activity Monitor displays that do not appear to have been executed.

Microsoft SQL Server Management Studio                      12.0.6024.0
Microsoft Analysis Services Client Tools                        12.0.6024.0
Microsoft Data Access Components (MDAC)                     6.3.9600.17415
Microsoft MSXML                     3.0 6.0 
Microsoft Internet Explorer                     9.11.9600.19375
Microsoft .NET Framework                        4.0.30319.42000
Operating System                        6.3.9600

None of the research I have done is providing me any clues as to why these jobs fail to execute. The description for all of these jobs is the same:

Status: Idle
Last Run Outcome: Unknown
Last Run: Never
Next Run: Not Scheduled
Category: Uncategorized
Runnable: No
Scheduled: about 1/2 Yes, about 1/2 No

I'm expecting to see that these jobs were successfully executed and completed.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
user3242558
  • 105
  • 1
  • 9
  • 1
    off-topic - belongs on [dba](https://dba.stackexchange.com/). But the version of SSMS is irrelevant here and that is what you posted. What is important is the version and edition of your database server instance. – SMor Nov 04 '19 at 18:42
  • Check the services on the server hosting your instance. Make sure that the SQL Server Agent is running. – BillRuhl Nov 04 '19 at 18:45
  • Thanks @BillRuhl - It is running. Runs all day and each day I have this long list of jobs that haven't run. – user3242558 Nov 04 '19 at 20:45
  • Are you certain that they are scheduled to run? Your post says Next Run: Not Scheduled. – BillRuhl Nov 07 '19 at 17:11
  • @BillRuhl If the job is complete or terminated, it also gets the 'not scheduled' status. – user3242558 Nov 08 '19 at 19:24

0 Answers0