Solved

SQL Server Agent running but not executing scheduled Job

Posted on 2011-09-11
10
259 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
10 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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