Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-08-30 : 00:48:15
|
| Dear All,I have Created a DTS Package In Enterprise manager.I need to make it as a scheduled How can i Do that onePlease Help meThanks and regardsKrishna |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-30 : 01:03:33
|
| just right-click on the package and go 'Schedule Package'Very simple.... |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-08-30 : 01:09:47
|
| Yes I have done The same.I have done The FollowingOccurs :DailyDaily freq :Occurs Every : 1 MinituesBut It 's Not ExecutedKK |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-08-30 : 01:10:29
|
| But I have done in the client...!Shall i goto Server..? |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-30 : 01:44:42
|
| It doesn't matter where you schedule it from (ie client or server), it should create a SQL Agent job for it. In Enterprise Manager, check Management->SQL Server Agent->Jobs. There should be a job created there if you've done it correctly. |
|
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-08-30 : 02:30:36
|
| Thanks timmy , i have one more Doubt , Please explain meI need to create a primary keyThis is the sample dataplease suggest the order C03_ORGANISATION_CODE C29_LOCATION_CODE H01_EMP_NUM Process_Period'A' 'B' 1 17'A' 'B' 2 17'A' 'B' 3 17'A' 'B' 4 17'A' 'B' 5 17'A' 'B' 6 17'A' 'B' 1 18'A' 'B' 2 18'A' 'B' 3 18'A' 'B' 4 18'A' 'B' 5 18'A' 'B' 6 18Thanks and regardsKrishna |
|
|
|
|
|
|
DTS