ERROR 22022: SQLServerAgent is not currently running so it cannot be notified

• BossCo

  Old Hand

  Points: 327

  More actions

  August 26, 2021 at 9:28 am

  #3924139

  Hello everyone, I need to solve a huge problem I have when I try to create a job with SQL Server Agent.

  The job is very simple: I need to process, once a day, some tables into an SSAS tabular model.

  I can create the job and schedule it without problems, but when I try to click on "Start Job at Step" I got my error: ERROR 22022: SQLServerAgent is not currently running so it cannot be notified of this action.

  Of course it is running, I checked both my Windows activities and my SQL Server Configuration Manager. It starts automatically. And yes, Agent XPs is enabled. Here's my SQL Server Agent log (sorry for the Italian), but I see nothing wrong.

  021-08-25 18:35:31 - ? [000] Event Global\sqlserverRecComplete opened

  2021-08-25 18:35:31 - ? [100] Microsoft SQLServerAgent versione 14.0.1000.169 (build X64 unicode finale): ID processo 7048

  2021-08-25 18:35:31 - ? [495] L'account del servizio di avvio di SQL Server Agent è NT SERVICE\SQLSERVERAGENT.

  2021-08-25 18:35:34 - ? [393] In attesa del recupero del database 'msdb'...

  2021-08-25 18:35:36 - ? [000]

  2021-08-25 18:35:37 - ? [101] SQL Server DATA versione 14.00.1000 (limite di connessione 0)

  2021-08-25 18:35:37 - ? [102] Driver ODBC SQL Server versione 14.00.1000

  2021-08-25 18:35:37 - ? [103] La NetLib utilizzata dal driver è DBNETLIB. Il server host locale è DATA

  2021-08-25 18:35:37 - ? [310] Rilevati 4 processori e 16220 MB di RAM

  2021-08-25 18:35:37 - ? [339] Nel computer locale DATA è in esecuzione Windows Server 2019 Essentials 10.0 (17763).

  2021-08-25 18:35:38 - ? [432] La cache dei sottosistemi contiene 12 sottosistemi.

  2021-08-25 18:35:39 - ? [129] Avvio di SQLSERVERAGENT sotto il controllo del servizio di Windows NT in corso

  2021-08-25 18:35:39 - + [475] Posta elettronica database non abilitata per le notifiche dell'agente.

  2021-08-25 18:35:39 - + [396] Non è stata definita una condizione di inattività della CPU. Le pianificazioni del processo OnIdle non avranno effetto.

  I also tried to restart SQL Server Agent, and my SQL Server, too. Nothing to do.

  I really don't know which kind of problem is this.

  Thanks a lot!

   

  EDIT: My SQLServerAgent was not running on the SQL Server, only on the server containing the Analysis Services project

  • This topic was modified 3 years, 9 months ago by BossCo.

• Michael L John

  One Orange Chip

  Points: 27079

  More actions

  August 26, 2021 at 8:04 pm

  #3924305

  BossCo wrote:

  EDIT: My SQLServerAgent was not running on the SQL Server, only on the server containing the Analysis Services project

  The agent needs to be running on the server where the job is running from.

  Also, in order to process the cube, the SQL Agent service account will need to be granted permissions on the SSAS database.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/