?
Solved

SQL Server Agent running but not executing scheduled Job

Posted on 2011-09-11
10
Medium Priority
?
265 Views
Last Modified: 2012-05-12
Hi,

From Last 3-4 days, SQL Server Agent not executing scheduled Jobs. However, SQL Agent is running.

I have checked thoroughly and found that reason is login failed for user "sa".


Untitled.png
0
Comment
Question by:Alpesh Patel
  • 4
  • 2
  • 2
8 Comments
 
LVL 19

Expert Comment

by:Rimvis
ID: 36521090
Judging from the error, sa login is unable to access specified database. There are to possibilities:
1) Database specified in job is unavailable to sa login, or does not exists;
2) Default database for sa login is unavailable, or does not exists.
0
 
LVL 21

Author Comment

by:Alpesh Patel
ID: 36521143
Rimvis

Both options are available.

0
 
LVL 21

Author Comment

by:Alpesh Patel
ID: 36527428
I've requested that this question be deleted for the following reason:

I got solution ownself. There is no issue related to this
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
LVL 19

Expert Comment

by:Rimvis
ID: 36527429
PatelAlpesh,

If you found the solution, please post it here, so other may benefit from it. Then your own answer could be accepted as solution.
0
 
LVL 21

Accepted Solution

by:
Alpesh Patel earned 0 total points
ID: 36534172
changed password of sa and updated SQL Jobs.
0
 
LVL 21

Author Comment

by:Alpesh Patel
ID: 36553620
I've requested that this question be closed as follows:

Accepted answer: 0 points for PatelAlpesh's comment http:/Q_27302694.html#36534172
Assisted answer: 0 points for PatelAlpesh's comment http:/Q_27302694.html#36521143
Assisted answer: 0 points for PatelAlpesh's comment http:/Q_27302694.html#36527428

for the following reason:

changed password of sa and updated SQL Jobs.
0
 

Expert Comment

by:South Mod
ID: 36553621
Objecting to re-award points.

SouthMod
Community Support Moderator
0
 

Expert Comment

by:South Mod
ID: 36578984
Starting the auto-close procedure on behalf of the question asker. Please see the referenced question for more details.

SouthMod
Community Support Moderator
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question