SQL Server 2000 SP3 running on Windows 2000 Server SP2.

Thanks Steve. I am debugging a situation in piece by piece fashion.

Yes. Most of them. The jobs which are running while other jobs are not running also created by mentenance jobs.

Apart from that I have non-maintenance plan jobs whihc are running...

Thanks Allen. But.... here is my problem.

I am having one strange problem, my jobs are not executing in fixed intervals.

Couple of days back we had a situation that the...

toni,

I have seen this error for couple of reasons on my non-prod servers last week. THis is a generic error...

Can you paste the contents of ...Microsoft SQL Server\MSSQL\LOG\SQLAGENT.OUT. You might...

Thanks to Steve & annejo for your inputs.

I used to have my NT name as my user ID on few forums. But I didn't receive any cricism from NT Admin, but didn't feel secure myself having the...

Frank,

I guessed it few months back when I saw your ID. :)... Because I did the same a while back... 🙂

Which SQL Server are you running?!

If you are running SQL Server 7.0 or SQL Server 2000, the easiest way is to

1. Stop the Services on your machine.

2. Copy YourDatabaseName.MDF...

Yes. Outlook 2000 is installed on the box as SQL Server 2000 running.

But how do we check if this is HUNG or Running with FAILURE/SUCCESS?

Do we need to check few times in a day whether the jobs are running not not?!

Does anyone...

Since this very time critical, I have rebooted the Server. Now everything seems to be working. But I still didn't understand what went wrong.

Can someone help.....

I ran into the same situation few months back... These Index are created by the SQL Setver itself to optimise the query performance based on the usage.

This feature started from...

Can you check if the "Auto start when OS starts" box is checked in the Server Manager for "SQLServer Agent"?

Thank You Allen. I would uninstall SQL Server 2000 from this machine now (I just installed this morning), then install SQL Server 6.5 (as named instance), then SQL Server 2000...