SQL Server Performance

SQL Server Agent Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action

Discussion in 'SQL Server 2005 General DBA Questions' started by baburk, Jul 7, 2008.

  1. baburk New Member

    Hi everybody,
    First my SQL Server Agent XPs disabled
    So I used the below URL and run the command and get it enabled.

    http://www.rprabhala.com/Dasblogce/blog/PermaLink,guid,ee1c2143-5e5a-46de-9685-f096a674121b.aspx

    Then I Right Click Jobs in Sql Server Agent and created New Job with Name CommissionCalculation and Category as DataBaseMaintenance. In the step I created new StepName as CommissionCalculation In the Command I gave EXEC sp_Commission and the database as TEST
    In schedules I gave name as CommissionCalculation schedule type as Recurring. Then I give when to run and gave Ok .
    This is how it is given in the path
    http://msdn.microsoft.com/en-us/library/ms189258.aspx#Mtps_DropDownFilterText
    When I right click CommissionCalculation and gave Start Job I got this error.
    Error 22022: SQLServerAgent is NOT currently running so it cannot be notified of this action



  2. kvdba New Member

Share This Page