Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    114

    Unanswered: SQL Server Scheduled Job

    None of my scheduled jobs are working. I am trying to back-up databases individually by scheduling them for once a day and I have a maintenance plan that is not running. I go into 'Jobs' under 'SQL Server Agent' in the 'Maintenance' folder and everything is good except the 'Status' is 'Not Running' and the 'Last Run Status' is 'Failed.' Any ideas?

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    Are your jobs enabled? Does the user who runs the jobs have the proper permissions? Try to execute the job manually. Maybe you can determine at what point the error occurs.
    Johan

  3. #3
    Join Date
    Jul 2002
    Posts
    63
    Check that your SQL server agent is started

  4. #4
    Join Date
    Apr 2003
    Posts
    114
    It is

  5. #5
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    What are the error messages? Who is the job owner? You may try changing the job owner to SA if it is not already.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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