|
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: 6248
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: 6248
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: 6248
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: 19243
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 |
|
|
|
|
