[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

SQL Server Agent running but not executing scheduled Job

Posted on 2011-09-11
10
Medium Priority
?
263 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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

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 …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

656 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