DB2 Scheduler

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

db2inst2 - 12 Jun 2006 09:31 GMT

Hi

I have posted this question on IBM's DB2 forums without much success
and I hope I'll have success here.

I would like to know if there is a way to create a scheduled job in DB2
(I'm using DB2 8.1 on Linux) without having to use the DB2 Task Center
GUI. Ideally, I'd like to create a set of stored procedures that
accept job parameters (much like msdb.dbo.sp_add_job in MSSQL) and
update the scheduler tables accordingly.

According to what I have read, there is no public API on DB2 that
allows this functionality.

If this is indeed possible by inserting schedule information into the
tools cataglog directly, will DB2 necessarily pick this up?

Any advice would be greatly appreciated.
Thank you.

Reply to this Message

Mark A - 12 Jun 2006 10:42 GMT

> Hi
>
[quoted text clipped - 15 lines]
> Any advice would be greatly appreciated.
> Thank you.

Are you familiar with Linux/UNIX cron jobs? This is a scheduler build into
the OS. You could create the SP's to access DB2 tables (that you create)
with the parms and write to a another table with the job status.

Reply to this Message

db2inst2 - 12 Jun 2006 11:54 GMT

Hi Mark, thankyou for your reply.

I have considered this but my aim is to create a generic set of
scheduler stored procedures that work with the database (MSSQL or
DB2LUW) scheduler. This is easy with MSSQL because these stored
procedures (such as sp_add_job, sp_add_job_step, etc) are exposed.

Reply to this Message

Knut Stolze - 12 Jun 2006 11:51 GMT

> Hi
>
[quoted text clipped - 9 lines]
> According to what I have read, there is no public API on DB2 that
> allows this functionality.

The scheduling information is stored in the tools catalog. You can add your
own jobs by modifying the respective tables.

> If this is indeed possible by inserting schedule information into the
> tools cataglog directly, will DB2 necessarily pick this up?

I would think so, yes.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

db2inst2 - 12 Jun 2006 11:59 GMT

Thank you for your reply Knut,

There are however quite a few tables and views within the tools catalog
that I have created. I intend to monitor how these tables are changed
by the Task Center GUI and to attempt a manual insertion. This strikes
me as a bit labour-intensive but I will probably resort to this if
there is no simpler way to achieve this.

Thanks

> > Hi
> >
[quoted text clipped - 22 lines]
> DB2 Information Integration Development
> IBM Germany

Reply to this Message

db2inst2 - 12 Jun 2006 12:47 GMT

Hi Knut,

I have one other question, is there manual or spec that I could use to
determine how the integer values map in the scheduler tables? (for
instance INTERVAL_DETAIL of 5 means day of month).

Thanks.

> > Hi
> >
[quoted text clipped - 22 lines]
> DB2 Information Integration Development
> IBM Germany

Reply to this Message