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 |
|
harsha_bhagat
Starting Member
2 Posts |
 Posted - 2007-12-19 : 08:50:30
|
| Hi,I want help,I want to run the job as per my schedule. I mean I will store the time in a table and the job should run on that interval time. If i say that it has run at 1700 hrs then it should run at 1710 mins then it should run at 1725. Any help please. |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-12-19 : 08:56:06
|
| You can make use of sp_add_jobschedule system stored proc and supply its parameter values from table data.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
harsha_bhagat
Starting Member
2 Posts |
Posted - 2007-12-22 : 04:54:57
|
Hi,I had tried with this....But no help.It is running at the interval of 1 min. not with the time as I am specifying. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-22 : 21:10:11
|
| You can have multiple schedules for a job. |
|
|
|
|
|
|
Job Scheduling