Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Agent

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-08 : 09:57:51
Anthony Ozogu writes "I had setup a DTS to run at a certian time in my SQL server 7 but that does not happen. Do I need to have the SQL Sever Agent running before the DTS or sp could be executed automatically? The SQL server and the agent cannot run at the same time as I found out. help, thanks."

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-03-08 : 09:57:51
You do need SQL Server agent running to schedule tasks. That's what runs them. SQL Server and SQL Server agent should be running at the same time. They do on all my systems. What problems did you have running SQL Server agent?
Go to Top of Page
   

- Advertisement -