DTS and SQL Server Agent - stop it or not?

[VincentMartin]

Hi Folks,

This is probably a REALLY daft question, but...

I'm trying to schedule and save a DTS package, but when I try and finish I'm told that I can't because the SQL Server Agent is running. Must I stop the Agent to complete this package?

Thanks in advance for your patience...

VM

 

[JayKusch]

Interesting ... usually it is just the opposite ... SQL Server needs to be started. Can you post the exact error message you are receiving when you are scheduling the job that calls the DTS package.

Thanks

J. Kusch

 

[VincentMartin]

Hi,

Thanks for the reply. When I try and create a DTS package, the package is saved alright, but when it tries to schedule the package, I get an error that this cannot be performed while SQL Server Agent is starting.

Can you help?

Thanks again,

VM

 

[JayKusch]

The SQL Server Agent should, in most cases, not take too much time in starting up. You may need to look at the SQL Server Agent service and make sure everything is OK and that it is started and functioning.

Thanks

J. Kusch

 

[nigelrivett]

dts is a client application and doesn't have anything to do with sql server - although packages may be saved in msdb, may have connections to sql server and may be rn from the agent via a command line exe (dtsrun).

Sounds like you are trying to schedule the package using the wizard (this will encrypt the call to dtsrun in the job step which I never like).
The wizard just does a create job for the dtsrun command.
The message you are getting sounds like there is a problem with the agent and it is failing to complete it's startup.

Try creating a job manually - if that works then there is a problem with the wizard - just code the dtsrun yourself.

More likely you will get an error. Try starting the agent - probably won't work. Have a look in the event log and see what it says.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.