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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2006-12-04 : 04:46:28
|
| Hello friends!I want to set my job agent to schedule for second basis but in EM i found by right clicking job in EDIT Recuring Job Schedule i m getting option in Hr and MM but not in SS so where i can set this in seconds (SS) or through QA????T.I.A |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-12-04 : 06:43:26
|
| You can't run a job in increments of a second. A minute is the smallest increment you can use.Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-04 : 07:25:08
|
| You can schedule a job to run every minute which calls an sp. That sp can then schedule whatever you want down to the second (or less). The scheduler then is just to restart the sp if it crashes.It's a shame - you used to be able to edit the system table to get a per second schedule. Now it takes quite a long time to add the task back into the scheduler after it completes which might have something to do with it being removed.==========================================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. |
|
|
|
|
|
|
job agent to schedule for second basis ????