x

SQL 2000 Agent Jobs for Backup

Hi everyone,

I am having problem with my Jobs which are created under SQL Job Agents, it was working fine for ages and start from last week, all the jobs NEXT RUNNING DATE are changed to 'Date and Time and Not Available' for all jobs.

I have restarted the Agents but still problem is exists.

Anybody know how to resolve this issue?

Thanks.

more ▼

asked Jan 19, 2010 at 07:18 AM in Default

Leo gravatar image

Leo
1.6k 54 56 58

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Open each job and look if it is enabled, and if it has a schedule, and what the schedule looks like. Sounds like something happened around there.

more ▼

answered Jan 19, 2010 at 07:21 AM

Steinar gravatar image

Steinar
1.7k 3 4 6

Yes, all enabled and has a schedule. I have create a new job and come up with the same problem when I click on Save.
Jan 19, 2010 at 11:03 AM Leo
In that case this might be the problem: http://support.microsoft.com/kb/825042
Jan 19, 2010 at 11:30 AM Steinar
(comments are locked)
10|1200 characters needed characters left

Is there anything in the agent logs that might indicate an issue?

Did the restart actually start the agent successfully without error?

more ▼

answered Jan 19, 2010 at 08:58 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

Yes. It is restarted without error.
Jan 19, 2010 at 11:04 AM Leo
(comments are locked)
10|1200 characters needed characters left

Hi Guys... Thanks for your help. I restarted my Server last night and now problem is solved.

more ▼

answered Jan 20, 2010 at 07:47 AM

Leo gravatar image

Leo
1.6k 54 56 58

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x737
x476
x91

asked: Jan 19, 2010 at 07:18 AM

Seen: 2261 times

Last Updated: Jan 19, 2010 at 08:53 AM