Post reply

SQL SERVERAGENT (208 - JOB Engine)

  • June 1, 2009 at 10:39 am

    #155766

    Date6/1/2009 3:00:00 AM

    LogJob History (NIIS_STATUXXXPURGE)

    Step ID0

    ServerSQLTEST

    Job NameNIIS_STATUXXXPURGE

    Step Name(Job outcome)

    Duration00:00:00

    Sql Severity0

    Sql Message ID0

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    The job failed. Unable to determine if the owner (sa) of job NIIS_XXX has server access.

    Verified that SA is correct

  • June 1, 2009 at 12:22 pm

    #1002957

    I guess your question is how to make the job run? I've only seen this happen when the owner is a domain account and changing the owner to sa (a local SQL Server account) fixed it.

    Greg

  • June 1, 2009 at 1:19 pm

    #1002992

    Fixed it. It looks like the SQL Server Agent was hung.

    DUHHH

    OPP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply