how to add a scheduled job for every 10 minutes?

I want to create a job that will work every 10 minutes. I am using wizards
in sybase central but I could not understand these wizards. If I set start
time, it is not recursive so I set start time 00:00 and finish time 23:59
because It should work every 10 minutes and every day. In my opinion I dont
need to set start and finish time. There is no end day. And on the last
page of wizard I set repeat every 10 minutes and all days of week.
But it does not work. It works only one time a day.

Please can I add a jop scheduled for every 10 minutes. It should be more
easy..

What operating system ?

On unix: use crontab.

Luc.


"Murat Yelkovan" wrote in message
news:48ae87e6-at-forums-1-dub...
>I want to create a job that will work every 10 minutes. I am using wizards
> in sybase central but I could not understand these wizards. If I set start
> time, it is not recursive so I set start time 00:00 and finish time 23:59
> because It should work every 10 minutes and every day. In my opinion I
> dont
> need to set start and finish time. There is no end day. And on the last
> page of wizard I set repeat every 10 minutes and all days of week.
> But it does not work. It works only one time a day.
>
> Please can I add a jop scheduled for every 10 minutes. It should be more
> easy..
>

Windows
Adaptive Server Enterprise/12.5.4/EBF 14656 ESD#6/P/NT (IX86)/OS
4.0/ase1254/2079/32-bit/OPT/Wed Jul 11 02:49:09 2007


"Luc Van der Veurst" wrote in message
news:48aeb517$1-at-forums-1-dub...
> What operating system ?
>
> On unix: use crontab.
>
> Luc.
>
>
> "Murat Yelkovan" wrote in message
> news:48ae87e6-at-forums-1-dub...
>>I want to create a job that will work every 10 minutes. I am using wizards
>> in sybase central but I could not understand these wizards. If I set
>> start
>> time, it is not recursive so I set start time 00:00 and finish time 23:59
>> because It should work every 10 minutes and every day. In my opinion I
>> dont
>> need to set start and finish time. There is no end day. And on the last
>> page of wizard I set repeat every 10 minutes and all days of week.
>> But it does not work. It works only one time a day.
>>
>> Please can I add a jop scheduled for every 10 minutes. It should be more
>> easy..
>>
>
>

I think scheduled job in database is a big lie.

"Murat Yelkovan" wrote in message
news:48ae87e6-at-forums-1-dub...
>I want to create a job that will work every 10 minutes. I am using wizards
> in sybase central but I could not understand these wizards. If I set start
> time, it is not recursive so I set start time 00:00 and finish time 23:59
> because It should work every 10 minutes and every day. In my opinion I
> dont
> need to set start and finish time. There is no end day. And on the last
> page of wizard I set repeat every 10 minutes and all days of week.
> But it does not work. It works only one time a day.
>
> Please can I add a jop scheduled for every 10 minutes. It should be more
> easy..
>

Hi,

If you are referring to the Job Scheduler in ASE, then could you please
get the sp_sjobhelp output for the scheduled job that you are referring to.

sybmgmtdb..sp_sjobhelp @name=''

Regards,
~Jaikishan

Murat Yelkovan wrote:
> Windows
> Adaptive Server Enterprise/12.5.4/EBF 14656 ESD#6/P/NT (IX86)/OS
> 4.0/ase1254/2079/32-bit/OPT/Wed Jul 11 02:49:09 2007
>
>
> "Luc Van der Veurst" wrote in message
> news:48aeb517$1-at-forums-1-dub...
>> What operating system ?
>>
>> On unix: use crontab.
>>
>> Luc.
>>
>>
>> "Murat Yelkovan" wrote in message
>> news:48ae87e6-at-forums-1-dub...
>>> I want to create a job that will work every 10 minutes. I am using
>>> wizards
>>> in sybase central but I could not understand these wizards. If I set
>>> start
>>> time, it is not recursive so I set start time 00:00 and finish time
>>> 23:59
>>> because It should work every 10 minutes and every day. In my opinion
>>> I dont
>>> need to set start and finish time. There is no end day. And on the last
>>> page of wizard I set repeat every 10 minutes and all days of week.
>>> But it does not work. It works only one time a day.
>>>
>>> Please can I add a jop scheduled for every 10 minutes. It should be more
>>> easy..
>>>
>>
>>
>

I have no problems creating a job that runs every 10 minutes. No lie. I
used Sybase Central to configure the job, and the schedule as you have
described it, and it's working fine. I set start time as "00:00" and end
time as "23:59" and yes, this makes sense as you might want to have a job
run every ten minutes, but say only during business hours, etc. When you
create the job, you have to associate it to a schedule.

I suspect that you don't have something setup correctly. Maybe the "disable
on failure", or "delete on completion" is set? Does the one-time job
execution complete successfully? Is your job definition based on a
template?

"Murat Yelkovan" wrote in message
news:48b2695e-at-forums-1-dub...
>I think scheduled job in database is a big lie.
>
> "Murat Yelkovan" wrote in message
> news:48ae87e6-at-forums-1-dub...
>>I want to create a job that will work every 10 minutes. I am using wizards
>> in sybase central but I could not understand these wizards. If I set
>> start
>> time, it is not recursive so I set start time 00:00 and finish time 23:59
>> because It should work every 10 minutes and every day. In my opinion I
>> dont
>> need to set start and finish time. There is no end day. And on the last
>> page of wizard I set repeat every 10 minutes and all days of week.
>> But it does not work. It works only one time a day.
>>
>> Please can I add a jop scheduled for every 10 minutes. It should be more
>> easy..
>>
>

If you have a single job to run and you want to use
job-scheduler it may not be a good idea.

you may use windows scheduled tasks --
start-settings-controlpanel-scheduled tasks.. remember to
have a username with password -noexpiry setting and use this
user to run the tasks. it works fine without any problem

thanks
ram

> Windows
> Adaptive Server Enterprise/12.5.4/EBF 14656 ESD#6/P/NT
> (IX86)/OS 4.0/ase1254/2079/32-bit/OPT/Wed Jul 11 02:49:09
> 2007
>
>
> "Luc Van der Veurst" wrote in
> message news:48aeb517$1-at-forums-1-dub...
> > What operating system ?
> >
> > On unix: use crontab.
> >
> > Luc.
> >
> >
> > "Murat Yelkovan" wrote in
> > message news:48ae87e6-at-forums-1-dub...
> >>I want to create a job that will work every 10 minutes.
> I am using wizards >> in sybase central but I could not
> understand these wizards. If I set >> start
> >> time, it is not recursive so I set start time 00:00 and
> finish time 23:59 >> because It should work every 10
> minutes and every day. In my opinion I >> dont
> >> need to set start and finish time. There is no end
> day. And on the last >> page of wizard I set repeat every
> 10 minutes and all days of week. >> But it does not work.
> It works only one time a day. >>
> >> Please can I add a jop scheduled for every 10 minutes.
> It should be more >> easy..
> >>
> >
> >
>