Thanks for the help. I've created a task and it also ran and updated the record.
But the status of the task shown is "Not Successfull". Retrun code = 0.
But it has updated the records properly. then why is that its showing that status??

-----Original Message-----
From: "Parthasarathy, Partha" <Partha.[Email address protected]
Sent: Wednesday, December 29, 2004 6:08 PM
To: "Iswariya Vasan" <[Email address protected]
Subject: RE: Scheduler Jobs in DB2 UDB 8.0



In the prev mail, I just gave an example.
db2 create tools catalog cc create new database toolsdb

If you want to know the syntax, you can refer to the site
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.common.doc/common/creatingtoolscatalog.htm

Partha

Original Message
From: Iswariya Vasan [ mailto:[Email address protected]
Sent: Wednesday, December 29, 2004 9:55 AM
To: Parthasarathy, Partha
Subject: RE: Scheduler Jobs in DB2 UDB 8.0


When I click on the scheduler system, it throws me an error saying that tools catalog is not available. How to create that?

Original Message
From: "Parthasarathy Partha " <Partha.[Email Address Removed] ent.com>
Sent: Wednesday, December 29, 2004 5:36 PM
To: <[Email address protected]
Subject: RE: Scheduler Jobs in DB2 UDB 8.0



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as normal
**Anything below this line is the original email text


Hi Ishwarya,
It is better to write a shell script and automate that through
the cron. But while doing so, don't forget to source the environment
for DB2 [running the .profile inside the script or setting the DB2
envirnoment variables explicitly]. We found this way easier as the Task
Manager needs the presence of TOOLS database and running correctly.
We have been running the SQLs through the crons and they are all runinng
fine.
Hope this information helps.
Good Luck.
Partha

Original Message
From: Iswariya Vasan
[ mailto:db2udbdba ezmlmshield x69769585.[Email address protected]
Sent: Tuesday, June 29, 2004 10:13 AM
To: LazyDBA Discussion
Subject: RE: Scheduler Jobs in DB2 UDB 8.0


When I clicked the task center, the scheduler system combo is not loaded with any values. How to add a job then???

Original Message
From: "LA RESERVE S Ext ROSI/SIPROD " <slareserve.[Email address protected]
Sent: Wednesday, December 29, 2004 5:05 PM


Use Task center via control Center


Message d'origine
De : Iswariya Vasan
[ mailto:db2udbdba ezmlmshield x49866141.[Email address protected]
Envoyé : mardi 29 juin 2004 17:00
À : LazyDBA Discussion
Objet : Scheduler Jobs in DB2 UDB 8.0



Hi all,

Can anybody guide me on how to create a scheduler (job) in DB2 UDB 8.0
version. I would be using this to write a job which will update the
records to a particular status in the table mentioned in the scheduler
each day.

Regards
Iswariya Vasan




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