Job Scheduler database (sybmgmtdb) installation help.

[sriram]

Hi,

I am installing Job scheduler on ASE 12.5.2 (Solaris 8). I would like to
know the syntax/format for "jobscheduler agent" in interfaces file. All the
Sybase docs are talking about directory services(($SYBASE/config/libtcl.cfg)
in this regard. We are using only interfaces file, no directory services.

If you have any sample interfaces file with "jobschedular agent" in running
condition, please post it or any doc which gives more details.

Any help in this regard is much appreciated.

Thanks,
Sriram

[wkraatz]

I have just started to play with the Job Scheduler. I have
had some success with the following entries. This in on an
AIX box.

Server Definitions:

sp_addserver AIX_SYBASE_4, local, AIX_SYBASE_4
go
sp_addserver SYB_JSAGENT, ASEnterprise, AIX_SYBASE_4_JSAGENT
go

Interfaces definitions:

AIX_SYBASE_4
master tcp ether aix2 2044
query tcp ether aix2 2044

AIX_SYBASE_4_JSAGENT
master tcp ether aix2 2025
query tcp ether aix2 2025

[sriram]

Hi,

Thank you very much for your responce. I did the setup similar to this
exactly, Still no luck.. if you have any doc, please point me. I am
following this doc.
http://sybooks.sybase.com/onlinebooks/group-as/asg1252e/jsusers/@Generic__BookTextView/1034

Regards,
Sriram

<wkraatz> wrote in message news:411b6fad.2b3...@sybase.com...

[wkraatz]

> Hi,
>
> Thank you very much for your responce. I did the setup
> similar to this exactly, Still no luck.. if you have any
> doc, please point me. I am following this doc.
>
http://sybooks.sybase.com/onlinebooks/group-as/asg1252e/jsusers/@Generic__BookTextView/1034
>
> Regards,
> Sriram
>

I downloaded the Job Scheduler User's Guide PDF t:

http://download.sybase.com/pdfdocs/asg1252e/jsusers.pdf

I* followed the instructions in Chapter 2, then the examples
in Chapter 3.

The examples in Chapter 3 have typos on page 17 that prevent
things from running.

1 Create the schedule:

sp_sjobcreate @name='sname=Aug_stats_trial',
@option='starttime=23:00,repeats=1day,startdate=1
August
2003,enddate=31 August 2003'

2 Create the job:

sp_sjobcreate @name='jname=new_stats_proc',
@option='jcmd=''exec
statsdb..new_stats_proc'',jdesc=New statistics
proc.,properties=shared'

3 Create a scheduled job on a server called “devtest1”:

sp_sjobcreate @name='sjname=new_stats_devtest1',
@option='sname=Aug_stats_trial,jname=new_stats_proc
,server=devtest1'

I had to correct like this:

1 Create the schedule:

sp_sjobcreate @name='sname=Aug_stats_trial',
@option='starttime=23:00,repeats=1day,startdate=1
August 2003,enddate=31 August 2003'

2 Create the job:

sp_sjobcreate @name='jname=new_stats_proc',
@option='jcmd=exec statsdb..new_stats_proc (removed
the '' and added new line following proc name)
,jdesc=New statistics proc.,jproperties=shared' (
key word is jproperties not properties )

3 Create a scheduled job on a server called “devtest1”:

sp_sjobcreate @name='sjname=new_stats_devtest1',
@option='sname=Aug_stats_trial,jname=new_stats_proc
,server=devtest1'