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 |
|
decapolo
Starting Member
15 Posts |
 Posted - 2005-12-26 : 01:27:35
|
| Hi!I m new to SQL Server. Can any1 please tell me the way schecule a procedure call such as it inserts the current date and time after evry hour.regards,Sam deCapolo |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-26 : 01:35:57
|
| Hi,You can create a DTS package that will execute the Procedure schedule the package to be executed daily with daily frequency as occurs every hour. |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-12-26 : 01:59:28
|
| You can also creat a job in SQL server under Management-->SQL Server Agent-->Jobs. Make sure the Sql server agent is running once you schedule the job. For more information about jobsYou can also check books online for more information.RegardsSachinDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
|
decapolo
Starting Member
15 Posts |
Posted - 2005-12-26 : 02:00:42
|
| Hi ...My apologies for my insolence but can you kindly help me with the creation of such a DTS package ...regards,Sam deCapolo |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-26 : 02:25:22
|
| refer this link..http://www.devarticles.com/c/a/ASP/Creating-DTS-Packages-With-SQL-Server-2000/ |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-26 : 03:10:54
|
| orHave a stored procedure that does the Insertion and schedule it in the job to run periodicallyMadhivananFailing to plan is Planning to fail |
|
|
|
decapolo
Starting Member
15 Posts |
Posted - 2005-12-26 : 03:37:49
|
| Hi ...thanx a lot guys ... the scheduling the job to run over periodic intervals worked ... am still trying to study the DTS thingy ... but yeah i have accomplished my task ... thanx!regardz,sAm |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-26 : 04:09:41
|
| Refer this for dts scriptswww.sqldts.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Insertion using DTS pakcage