I have a table with Sys_date and Flag field. If the flag is Y for system date(Todays Date) then I need to run data movement jobs. I need to implement the logic as It should keep quering the table to check the flag for todays date. As soon as It finds the flag as Y it should run my jobs. How can I achieve this. Please help me...
Thanks in Advance
Additional Info:
Backend is Oracle
Checking status flag before running Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Checking status flag before running Jobs
Use a BASIC job
In theory there's no difference between theory and practice. In practice there is.
-
- Participant
- Posts: 132
- Joined: Wed Mar 01, 2006 11:12 pm
- Location: Pune
Re: Checking status flag before running Jobs
I created a basic job that just reads from the table and if the flag is Y then it marks the job as finished ok and if the flag is N then it marks the job as Finished with warning.ogmios wrote:Use a BASIC job
I handled the finished condition in a job sequence to execute the next job. if the status is Ok the i run the next job and if the status is otherwise i abort the sequence job
Thnx...
SMB