DB2 Scheduler

[db2inst2]

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.

[Mark A]

"db2inst2" <tg*****@gmail.com> wrote in message
news:11**********************@i40g2000cwc.googlegr oups.com...

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.

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.

[Knut Stolze]

db2inst2 wrote:

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.
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[db2inst2]

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.

[db2inst2]

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

Knut Stolze wrote:

db2inst2 wrote:

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.

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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

[db2inst2]

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.

Knut Stolze wrote:

db2inst2 wrote:

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.

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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany