Solved

SQL Server Agent running but not executing scheduled Job

Posted on 2011-09-11
10
252 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
10 Comments
 
LVL 19

Expert Comment

by:Rimvis
Comment Utility
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
Comment Utility
Rimvis

Both options are available.

0
 
LVL 21

Author Comment

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

I got solution ownself. There is no issue related to this
0
 
LVL 19

Expert Comment

by:Rimvis
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 21

Accepted Solution

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

Author Comment

by:Alpesh Patel
Comment Utility
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
Comment Utility
Objecting to re-award points.

SouthMod
Community Support Moderator
0
 

Expert Comment

by:South Mod
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
This video discusses moving either the default database or any database to a new volume.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

743 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now