We have moved to www.dataGenX.net, Keep Learning with us.

Friday, August 30, 2013

Datastage Job Scheduler


Datastage includes a scheduling option, it does not have its own. DataStage doesn't include a "scheduler" so leverages the underlying O/S. For UNIX that means cron and a check of the crontab entries for the scheduling user will have what you need. DataStage leverages cron for recurring schedules and at for 'one off' schedules. For Windows, it uses scheduled tasks of Windows.

From the operating system command line, logged in as the scheduling user, a "crontab -l" will list the scheduled jobs.


You can schedule a job to run in a number of ways:
  • Once today at a specified time
  • Once tomorrow at a specified time
  • On a specific day and at a particular time
  • Daily at a particular time
  • On the next occurrence of a particular date and time

Steps :

From Director:

1. Select job
2. Add to Schedule (right-click or clock icon)
3. Select the 'Every' radio button
4. Make sure Monday thru Friday are highlighted
5. Set time to 9:00 AM
6. Click OK
7. Set parameters
8. Click Schedule

Procedure

Select the job or job invocation you want to schedule in the Job Status or Job Schedule view.
  1. Note: You cannot schedule a job with a status of Not compiled or a web service-enabled job.
  2. Do one of the following to display the Add to schedule dialog box:
    • Choose Job > Add to Schedule... .
    • Choose Add To Schedule... from the appropriate shortcut menu.
    • Click the Schedule button on the toolbar.Choose when to run the job by clicking the appropriate option button:
      Today runs the job today at the specified time (in the future).
      Tomorrow runs the job tomorrow at the specified time.
      Every runs the job on the chosen day or date at the specified time in this month and repeats the run at the same date and time in the following months.
      Next runs the job on the next occurrence of the day or date at the specified time.
      Daily runs the job every day at the specified time.
  3. If you selected Every or Next in step 3, choose the day to run the job by doing one of the following:
    • Choose an appropriate day or days from the Day list.
    • Choose a date from the calendar.
      Note: If you choose an invalid date, for example, 31 September, the behavior of the scheduler depends upon the operating system of the computer that hosts the engine tier, and you might not receive a warning of the invalid date. Refer to your documentation for the engine tier host for further information.
  4. Choose the time to run the job. There are two time formats:
    • 12-hour clock. Click either AM or PM.
    • 24-hour clock. Click 24H Clock.
      Click the arrow buttons to increase or decrease the hours and minutes, or enter the values directly.
  5. Click OK. The Add to schedule dialog box closes and the Job Run Options dialog box appears.
  6. Fill in the job parameter fields and check warning and row limits, as appropriate.
  7. Click Schedule. The job is scheduled to run and is added to the Job Schedule view.