Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help

Status
Not open for further replies.

dass

Programmer
Feb 25, 2002
33
IN
How can I Run a Package at a particular time Daily say 0955 hrs
 
you can do it in DTS-wizard when you create package
 
Right-click on your DTS package and click "Schedule package...".

Once you set the schedule, this just adds a job into SQL Agent. You can then edit it from the Jobs container within Enterprise Mgr:

[server]
--Management
----SQL Server Agent
------Jobs

--James
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top