View previous topic :: View next topic
|
Author |
Message |
sgiri Warnings : 1 New User
Joined: 07 Aug 2007 Posts: 20 Location: chennai
|
|
|
|
Guys,
I need to trigger an Annual job based on a DB2 table entry.
The Db2 table entry can happen any time in a year and the job has to be triggered exactly after 60 days from the date of the table entry.
The catch here is , we cannot use a daily job to check whether the DB2 entry has occured or not.
Is there a way to create such a job.. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
How is the table update actioned |
|
Back to top |
|
|
sgiri Warnings : 1 New User
Joined: 07 Aug 2007 Posts: 20 Location: chennai
|
|
|
|
The table is updated by a cobol program.
The program checks for a certain condition, which occurs only once a year. Based on that it inserts the value into the table. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Can you not set a return code through the program to indicate that the update was performed, and then using conditional execution process a batch interface to the scheduling software to schedule the required second job in 60 days time ? |
|
Back to top |
|
|
sgiri Warnings : 1 New User
Joined: 07 Aug 2007 Posts: 20 Location: chennai
|
|
|
|
Can you pls elaborate more on setting a return code through the cobol job. I have never set it before.. |
|
Back to top |
|
|
GlobalGyan
New User
Joined: 31 Jan 2006 Posts: 28
|
|
|
|
QW RETURN-CODE |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Not COBOL job, using COBOL program
Code: |
MOVE desired-RC TO RETURN-CODE. |
|
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
GlobalGyan wrote: |
QW RETURN-CODE |
Only if MVS/QuickRef is installed. |
|
Back to top |
|
|
GlobalGyan
New User
Joined: 31 Jan 2006 Posts: 28
|
|
|
|
Anuj Dhawan wrote: |
GlobalGyan wrote: |
QW RETURN-CODE |
Only if MVS/QuickRef is installed. |
Oh yes... true...
Are there systems where MVS/Qref not installed? What are the alternate solutions to this |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
GlobalGyan wrote: |
Are there systems where MVS/Qref not installed? What are the alternate solutions to this |
Of course there are.
Reference manuals are the usual method of obtaining information. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Or google... mmmm...may be goggle...sorry for fast fingures... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
The catch here is , we cannot use a daily job to check whether the DB2 entry has occured or not. |
By what rule/requirement? Sounds like nonsense. . .
I suspect that something could be added to an already existing daily process and not require an entire new job. . . |
|
Back to top |
|
|
|