Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Scheduling DTS Packages
Message
 
To
19/07/2006 12:19:38
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01137681
Message ID:
01137689
Views:
15
Mike,

What exactly do you mean by keeping your SQL Server logged in? How is the SQL Server service setup to run? It should be set to run automatically as some account. That will stay logged in as long as the server is on. There is also the SQL Server Agent service. It, too, should be set to run automatically. If you're talking about being connected to the Server (via Enterprise Manager), then no, you don't have to keep a connection to the server for the SQL Agent to run your DTS packages.

HTH,
Chad


>Hello,
>I am going to start scheduling a DTS package to run nightly. Do I have to keep my SQL Server logged in for it to run, or can I log out?
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Reply
Map
View

Click here to load this message in the networking platform