Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: not able to start any job...

    Hi,

    I am not able to start any SQL Server job. Trying to start a job from Enterprise Manger, I get no error but the job doesnt execute.

    Looks like in the Application Log there was an error 'Unable to read local eventlog'. Is this related to the problem or what should I do to fix this.

    Thanks for the help.

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: not able to start any job...

    What did the job history say?

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Did you make sure the agent is running?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    damn! scalped again
    Yeah... check your SQLServerAgent
    and check that the jobs arent disabled.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    On the server ensure the setting of event logs to overwrite as needed is enabled.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  6. #6
    Join Date
    Jan 2004
    Posts
    6
    Sorry all, I did not check from yesterday. I did check the agent it was running. And the job history was fine till whatever date I ran. I was not manually start the job. The job doesnt execute doesnt give any error...I stopped and started the SQL Server Agent and everything worked fine.
    Thanks to you all!

  7. #7
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    How about event viewer settings on the server?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  8. #8
    Join Date
    Jan 2004
    Posts
    6
    Originally posted by Satya
    How about event viewer settings on the server?
    Its set to 'override when needed'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •