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 |
|
davidth
Starting Member
5 Posts |
 Posted - 2010-08-03 : 04:04:57
|
| Hi guys,i have a job with schedule with a recursive with a 10 seconds periode. every days at 23:59:59 the job stop without any error and not running more times until i active manualy. any one know the reasons for this fact????thanks |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-08-03 : 06:37:19
|
| by default in SQL agent wizard for creating a job, smallest schedule period is 1 minute. |
 |
|
|
davidth
Starting Member
5 Posts |
Posted - 2010-08-03 : 06:49:44
|
| you can create periode for 10 secons with wizar. |
|
|
|
davidth
Starting Member
5 Posts |
Posted - 2010-08-03 : 06:52:50
|
| this is a report from wizar:Occurs every day every 10 second(s) between 0:00:00 and 23:59:59. Schedule will be used starting on 03/08/2010. |
|
|
|
ghemant
Starting Member
22 Posts |
Posted - 2010-08-05 : 06:53:38
|
| Can you post the error message so that it will be helpful for us to understand the issue better!!RegardsHemantgiri S. Goswami | SQL Server MVPhttp://www.sql-server-citation.com// |
|
|
|
|
|
|
Failed schedule job every days at 23:59:59