SQLServerAgent Error: Request to run job refused because the job is already running from a request by user

Topik


Pada posting dengan judul "SQLServerAgent Error: Request to run job refused because the job is already running from a request by user" ini akan diberikan penyebab dan mengatasi problem tersebut.

Penyebab masalah tersebut adalah ada job yang masih berjalan karena sesuatu hal atau dalam kondisi canceled.


SQLServerAgent Error: Request to run job refused because the job is already running from a request by user

SQLServerAgent Error: Request to run job refused because the job is already running from a request by user


Penjelasan


Untuk mengatasi hal tersebut adalah dengan membuka Activity Monitor yang ada di bagian SQL Server Agent dan lihat apakah ada job yang running atau canceled.

  1. Open SQL Management Studio on the database server;
  2. Connect to the database engine;
  3. In Object Explorer, expand your server, expand SQL Server Agent;
  4. Right-click Job Activity Monitor;
  5. Click View Job Activity.
Jika posisi running maka stop dahulu job-nya (bisa dilakukan di Activity Monitor) atau jika canceled bisa stop kemudian running ulang.


SQLServerAgent Error: Request to run job refused because the job is already running from a request by user


Semoga posting tentang "SQLServerAgent Error: Request to run job refused because the job is already running from a request by user" diatas dapat bermanfaat.


Salam,

Popular posts from this blog

K2 Error Value Cannot Be Null. Parameter Name: s In SmartView and SmartObject

Cara inject USB 3.0 Driver pada instalasi Windows - How to Inject USB 3.0 Driver in Windows 7

Pentaho Spoon Error : "Could Not Create The Java Virtual Machine"