During Report Subscription create we may get the below error.
Error:
The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help
Reason:
Report subscriptions are dependent on "SQL Server Agent". For each Subscription one job will create in the "SQL Server Agent". If the agent is not running or the user doesn't have proper permissions then the above error occurs.
If the SQL Server Agent is not running, follow the below steps to Start the Job Agent:
Error:
The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding) Get Online Help
Reason:
Report subscriptions are dependent on "SQL Server Agent". For each Subscription one job will create in the "SQL Server Agent". If the agent is not running or the user doesn't have proper permissions then the above error occurs.
If the SQL Server Agent is not running, follow the below steps to Start the Job Agent:
- Connect to server (where the SQL Server and SSRS installed). Go to the services
- Select "SQL Server Agent" and right click on it and select Start option.
No comments:
Post a Comment