I am trying to have a scheduled package run automatically. After I start the SQL Server Agent, I schedule the package for one or two minutes from now. When the moment arrives, I refresh the screen, and the status says "Not running." I have two questions: (1) How do I get the package to run at the designated time, and (2) how do I set the package to run automatically at the designated time on the Server if I am not present to open SQL Server on my machine? Maybe they are the same question. Thanks.
Joseph A. Koontz