FYI -- My shop uses Autosys for scheduling UNIX jobs and it works very
well.

-----Original Message-----
From: Goulet Dick
[mailto:db2udbdba-ezmlmshield-x60216722.[Email address protected]
Sent: Monday, August 29, 2005 9:36 AM
To: LazyDBA Discussion
Subject: RE: dbms_job.submit

Cron, while a decent utility for scheduling batch tasks, has one nasty
weakness, If your database or system is down when a job needs to run it
will either error out or not run at the scheduled time. So whenever
theirs a downtime period, scheduled or not, you have to remember the
cron entries that should have run at that time. Oracle's DBMS_JOB
package remembers not only time of next run, but the full date so
whenever the database restarts from the outage those jobs that should
have run will. It also has the advantage that there's no password out
in the open somewhere to be taken advantage of.

-----Original Message-----
From: Heijer Rob den
[mailto:db2udbdba-ezmlmshield-x59513627.[Email address protected]
Sent: Saturday, August 27, 2005 4:10 AM
To: LazyDBA Discussion
Subject: RE: dbms_job.submit


On our Unix systems, we use the crontab to submit whatever jobs,
including db2.

-----Oorspronkelijk bericht-----
Van: Amit Singal [mailto:db2udbdba-ezmlmshield-x81280897.[Email address
protected]
Verzonden: vr 26-8-2005 11:04
Aan: LazyDBA Discussion
Onderwerp: dbms_job.submit

DO we have any equivalent of dbms_job.submit in db2

dbms_job.submit procedure accepts three parameters, the name of the job
to
submit, the start time for the job, and the interval to execute the job:

Regards

Amit Singal







---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html

DB2 & UDB email list listserv db2-l LazyDBA home page