Solved

Can't create SQL jobs in SQL Server 2005

Posted on 2009-05-10
2
354 Views
Last Modified: 2013-11-30
Hi Experts,

When trying to create a SQL job in SQL Server 2005 I get the error message show in the screenshot. I tried with sa and most other logins. Any ideas?
Another interesting fact: I imported 3 SQL jobs from another SQL Server 2005 and even though the jobs run, I can't see anything (it shows empty) when opening the properties for the job. Other than those 3, I have not been able to create any jobs.
untitled.JPG
0
Comment
Question by:drotkopf
2 Comments
 
LVL 21

Accepted Solution

by:
Tapan Pattanaik earned 500 total points
ID: 24349613
0
 

Author Comment

by:drotkopf
ID: 24351029
This one was the one that helped:
http://support.microsoft.com/kb/938086/en-US 
I just installed SP2 (I'm sure I had installed it before...)
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

867 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

18 Experts available now in Live!

Get 1:1 Help Now