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 |
|
giridasmart1
Starting Member
4 Posts |
 Posted - 2008-09-17 : 12:48:07
|
| I have scheduled an SQL job for one time. But it running every 5 minutes once. Is that a bug from SQL server side ?can i know asap where the problem is ??? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 12:49:56
|
| Check you schedule tab in Job. What exactly did you choose? |
 |
|
|
giridasmart1
Starting Member
4 Posts |
Posted - 2008-09-17 : 12:53:35
|
quote:
Originally posted by sodeep
Check you schedule tab in Job. What exactly did you choose?
i hve choosen Schedule Type: One TimeEven though im getting the same problem |
|
|
|
giridasmart1
Starting Member
4 Posts |
Posted - 2008-09-17 : 13:11:57
|
| hey,atlast i got the error,the retry attempts is fixed to 5.some null field is throwing an error and it is trying to run for 5 more times as reattempt.ThanQ for posting reply with patience.. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-17 : 15:46:05
|
| You must have added job step like this.Thats why it is running 5 times.EXEC sp_add_jobstep @job_name @step_name @command @retry_attempts = 5, @retry_interval = 5 |
|
|
|
|
|
|
job scheduled for one time is re-running !!!!