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 |
|
slihp
Yak Posting Veteran
61 Posts |
 Posted - 2010-03-01 : 06:20:59
|
| Hi;not sure if this is the correct forum, if not can you suggest.anyway. i have a sql job scheduled to run a ssis package that appears to just stop. The schedule is set to run a ssis package every 3 minutes between 8am and 7pm weekdays indefinitely. it should never stop.i get an error if i try to start it, so i have top stop it first and then start it, but it is certainly not running as the last execution of the jobs is out with the 3minutes period. i have e-mail alerts set up for when the job fails, but i never receive any e-mails. i only discover this when users complain.any ideas, i don’t even know where to start looking. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-01 : 11:35:01
|
| what error do u get? |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-01 : 12:43:22
|
Not sure if I understand the problem correct.But maybe this?I am using an example:Job starts executing the package at 8am.The package needs more than 3 minutes to get ready.If so the job cannot start the next run at 8:03am.The next try will then come at 8:06am.The package (from first start) was ready at 8:04am so there is a gap.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2010-03-03 : 09:13:59
|
| russell:when i try to restart the job, i get a message that the job is already running, but as i said it last execution was outwith the 3 minutes. so i have to stop the job first then start it.fred;the job runs every three minutes, and the package exection time is about 8 seconds so it should never overlap. although this is an avenue that i could investigate but would have to wait for the error appear again. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-03-03 : 09:41:37
|
| if you can stop it. then it's running.maybe there are multiple schedules for this job |
|
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-03-03 : 12:32:31
|
| You need to check the Job execution time. Looks like next execution is overlaping the previous one.With RegardsSR |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-03-03 : 12:39:48
|
quote:
Originally posted by SreenivasBora
You need to check the Job execution time. Looks like next execution is overlaping the previous one.With RegardsSR
That's in short and clear words what I meant 
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
SQL Job Appears to stops