DataStage scheduling
Moderators: chulett, rschirm, roy
DataStage scheduling
Windows Server, version 7.1.
We use the DataStage Scheduler regularly, but we usually schedule jobs to run every Saturday, every 1st of the month, stuff like that. It works great for that. However, we have some jobs that we need to schedule once a month, but not always on the same day. Is there a way to schedule on a certain date each month? Is it any different in version 7.5, because we'll be upgrading to that soon?
We use the DataStage Scheduler regularly, but we usually schedule jobs to run every Saturday, every 1st of the month, stuff like that. It works great for that. However, we have some jobs that we need to schedule once a month, but not always on the same day. Is there a way to schedule on a certain date each month? Is it any different in version 7.5, because we'll be upgrading to that soon?
Eric
The scheduler in DataStage is just a front-end for the actual tool. The default scheduler on UNIX systems is cron, and that is what you are likely to be using.
If you want to do things not available in the GUI you can always edit your crontab manually, but you can specify a job to run every month on a given day; select the run to "every" and remove the DOW entry and just click on the day-of-month.
If you want to do things not available in the GUI you can always edit your crontab manually, but you can specify a job to run every month on a given day; select the run to "every" and remove the DOW entry and just click on the day-of-month.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For the jobs that we run on every "1st", yes. We have jobs that run on a "set schedule", but not one that we can schedule using "every 1st" though. For example, we might have a job that runs on "work day -4" for us each month. That would be December 27th, January 26th, February 23rd, March 28th, etc. So, we KNOW the exact dates that we need to run on, but it is not a date that we can currently schedule using the DataStage Scheduler in version 7.1.ray.wurlod wrote:Surely what you're already doing ("every 1st") covers what you've asked?
Eric
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Hi EJRoufs,
You can achieve this scheduling scenario like this in unix.
1) Use a parameter file which stores the date on which the job should be scheduled.
2) Write a shell script to pick the date from the parameter file and run the DataStage Job on that particular day.
3) First you need to schedule the Shell script daily. It check the parameter file daily for date. Wirte the logic in such a way that if the parameter file is empty dont do anything else if any valid date is present in the parameter file, start scheduling your datastage job using another script.
This should work. I am giving you an idea but I havent tried. pls do this and tell me whether this works fine or not.
Thanks,
Shab
You can achieve this scheduling scenario like this in unix.
1) Use a parameter file which stores the date on which the job should be scheduled.
2) Write a shell script to pick the date from the parameter file and run the DataStage Job on that particular day.
3) First you need to schedule the Shell script daily. It check the parameter file daily for date. Wirte the logic in such a way that if the parameter file is empty dont do anything else if any valid date is present in the parameter file, start scheduling your datastage job using another script.
This should work. I am giving you an idea but I havent tried. pls do this and tell me whether this works fine or not.
Thanks,
Shab
Schedule DataStage Job Monthly but on different Days.
Hi EJRoufs,
You can achieve this scheduling scenario like this in unix.
1) Use a parameter file which stores the date on which the job should be scheduled.
2) Write a shell script to pick the date from the parameter file and run the DataStage Job on that particular day.
3) First you need to schedule the Shell script daily. It check the parameter file daily for date. Wirte the logic in such a way that if the parameter file is empty dont do anything else if any valid date is present in the parameter file, start scheduling your datastage job using another script.
This should work. I am giving you an idea but I havent tried. pls do this and tell me whether this works fine or not.
Thanks,
Shab
You can achieve this scheduling scenario like this in unix.
1) Use a parameter file which stores the date on which the job should be scheduled.
2) Write a shell script to pick the date from the parameter file and run the DataStage Job on that particular day.
3) First you need to schedule the Shell script daily. It check the parameter file daily for date. Wirte the logic in such a way that if the parameter file is empty dont do anything else if any valid date is present in the parameter file, start scheduling your datastage job using another script.
This should work. I am giving you an idea but I havent tried. pls do this and tell me whether this works fine or not.
Thanks,
Shab
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DataStage Scheduling
ray.wurlod wrote:Did you notice that the original poster is on Windows?
Then write a dos batch script on windows NT or through datastage basic routines.....or Job control routines.....I said an example on Unix
![Idea :idea:](./images/smilies/icon_idea.gif)
![Surprised :o](./images/smilies/icon_surprised.gif)