Hi,

Thanks for your reply.

Actually there were only 1600 records in that table and only 15 small columns were there in that table. And SQL Server as such was not hang....

Yipppeeeeeeeeeeee....................

Reinstallation of SP3a has done the trick. But dont know how...

There is nothing in the SQL Agent Error Log or Windows Log.

And I tried the Reporting file too but that file never get created. I created it myself but still...

Yes, for sure the schedule is also enabled and the time is also correct. and moreover when i try to run it manually then too it neither gives any error...

Hi,

Computer name has not been changed. And there was not any job or plan earlier on this server.

But Transaction Log backup job through DB Maintenance Plan is working and if...

Yes,

It is started with the account who has the appropriate permissions

Well Thanks for your efforts.

Is there any body else who can help me out in this matter???

It is just 100 MB but i tried to run it for a new Database which I just created for this purpose only and its not working for that too.

...

By this I mean that I have the Log On Account for SQL Server Agent who is having the appropriate permissions means that account has the sa rights in SQL...

I am running SQL 2000 with SP3a on Windows 2000 Standard Server with SP4.

Yes I created the Maintenance Plan through Wizard only.

One more interesting thing is that if I make...

well...

1) The job is simply taking a full Backup of one of the User Database which is coming through DB Maintenance Plan.

2) Its owner is sa

3) Just a single step...

EXCUSE ME.......

now let me see whether u r able to resolve this issue and how long will it take for u to solve this.

the problem is that it is activated...

EXCUSE ME.......

now let me see whether u r able to resolve this issue and how long will it take for u to solve this.

the problem is that it is activated...

Thanx Mccork

It solves my problem