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 |
|
densma
Starting Member
21 Posts |
 Posted - 2004-04-30 : 12:59:23
|
| I have package scheduled and saved. i created through import wizard..this should run once a day but for some reason it running twice and I can't figure out how to fix this. i only want it to run once a day to avoid duplicate record. Also how can i create log to see when/time package ran? |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2004-04-30 : 15:04:03
|
| In EM expand your SQL Server, then expand the management folder, then SQL Server Agent, click on jobs. In the right hand pane will be the sceduled job you created with the wizard (among others). Right click it and select View job history, you will see a list of times when the job ran.;-]... Quack Waddle |
 |
|
|
densma
Starting Member
21 Posts |
Posted - 2004-04-30 : 15:46:41
|
| thanks..what happened i right click on dts package and schedule package.. thot i was editing the schedule but.. instead creating new jobs lolim new to DTS |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-05-01 : 01:17:51
|
| lol - I've seen companies which need a package to run every hour so they make 24 copies of the package and schedule each of them once.Common reason for using dts is "We have to use dts because it needs to be scheduled" not realising that dts is nothing to do with scheduling but just has a wizard to add to the scheduler.By the way I would advise coding the dtsrun statement in the scheduler yourself so that you can see the package that is scheduled rather than the encrypted string.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
package schedule and logs