?
Solved

SQL Server Agent running but not executing scheduled Job

Posted on 2011-09-11
10
Medium Priority
?
261 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
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…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

752 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