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 Mike Lewis 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
0
0
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