Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Scheduling DTS Packages
Message
 
À
19/07/2006 12:19:38
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Versions des environnements
SQL Server:
SQL Server 2000
Divers
Thread ID:
01137681
Message ID:
01137689
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform