You can also check under the Services console, where you can view both the Agent and SQL Server services:

1. Right click on My Computer

2. Click on Manage

3. Open up Services...

That makes sense. What I did was create a job that will run every minute to check if there are any 0s letft. If there are 0s, it will do...

Lucky, that will work. However, I have close to 300 servers that I need to push this and possibly more than one DTS package. I was hoping to be able...

I FINALLY found a solution to this.

In case someone faces this problem in the future, here is the solution:

On the Windows server, open a command promt, type db2cmd enter. This...

Ok, what should the boot.ini file be for a:

Dual core 4 processor (looks like 8 in task manager), W2K3 Enterprise, 16 GB of RAM, Running SQL 2000 SP4, and SQL...

Thanks John and Lucky, that worked. Where can I send the checks?

Sureshkumar,

I'm curious why you did not include SQL's native Multi-Server administration system that allows you to schedule, monitor, and report on jobs from a centralized server (MSX the Master) of other...

Ok, this is the log:

The execution of the following DTS Package failed:

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Descriptionackage failed because Step...

I would then try Ed's suggestion above. If that doesn't work, I guess I would create another MSX/Master server, try to join this one to it, and then try to...

That worked great, thanks!

Have you tried defecting from the MSX server:

Right click on SQL Server Agent (under Management) in Enterprise Manager, then choose Multi-Server Administration, then click on Defect from MSX.

No permissions on the server, but the sql log in they use currently has serveradmin rights on the SQL instance.

In our case we have Help Desk associates who add and delete users on legacy applications, where the application authentication is done via sql login. I was trying to find...

Thanks for the heads up. I was about to apply the following:

SC stop SQLSERVERAGENT

ping -n 11 127.0.0.1 >NUL

SC \\localdc config SQLSERVERAGENT obj= domain\userid password= cavangar

SC stop MSSQLSERVER

ping -n 11...

BOL is Books On Line. While you're in SQL Enterprise Manager, hit the F1 key on your keyboard, or click on help. Then, in the search or index window, type...