Post reply

SQL job doesn't start

  • December 6, 2007 at 7:53 am

    #177238

    This problem is on SQL Server development box.

    SS 2K standard edition

    SP3

    3071 MB

    2 processors

    Windows NT 5.0

    SQL job doesn't start nor write on the view history. I have comfirm this by creating a new job with query and run it manually or schedule automatic run.

    select * from sysdatabases

    It points to database master and using the same account sql server agent uses it to start. This account has sys admi rights. I have check for blocking but thre is not.

    Anyone has ever has a similar issue like this

  • December 6, 2007 at 12:40 pm

    #757832

    Is SQL Server Agent running?

    Greg

  • December 6, 2007 at 1:57 pm

    #757860

    Yes

  • December 6, 2007 at 2:28 pm

    #757870

    restarted the sql server agent and it worked...weird thing.

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

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