locked
Exec sp_start_job report error in SQL Server 2005 Express Edition. RRS feed

  • 問題

  • While I executed sp_start_job in SQL Server 2005 express edition, why it report error as following;


    Execute:
    EXEC dbo.sp_Add_jobserver
        @job_name = N'Test3' ;
    Result:
    Successful

    Execute:
    EXEC dbo.sp_start_job N'Test3'
    Result:
    Msg 22022, Level 16, State 1, Line 0
    SQLServerAgent is not currently running so it cannot be notified of this action.

    2006年10月16日 上午 03:47

解答

所有回覆