How can I check my job status in DataStage?

How can I check my job status in DataStage?

DataStage Director Toolbar Options Select the Job Status view. Select the Schedule view. Select the Job Log view. Search for a job.

Which is used to schedule jobs in DataStage?

Use the job scheduling features of IBM® InfoSphere® DataStage® and QualityStage® to automatically run jobs at specified times, days, or intervals.

How do I find long running jobs in DataStage?

ps -ef | grep DSD.RUN “Inv_Rep3_word” and “stand1” is the running job names. We can use this command in shell script to get the list of running jobs whenever we want or can schedule in cron to get hourly report.

How do I get a list of all DataStage jobs?

Command Syntax: dsjob [-authfile | -file | [-domain | -url ] -user -password -server ] | -domain [-user ] -server [] Valid primary command options are: -run – …

How do you use Dsjob?

Procedure

1. Open a terminal session or a command line interface.
2. Provide authentication information where necessary.
3. Run the dsjob command to run the job. The following command runs the Build_Mart_OU job in the dstage project. The default parameters are used when running the job.

What are the first two steps you should take to understand the job performance issues?

What are the first two steps you should take to understand the job performance issues? take to understand the job performance issues? (Choose two.) Review the objectives of the job. Run job with $APT_TRACE_RUN set to true.

How can you find out whether DataStage process is running or not in Unix?

1. Log into your Unix/Linux machine as root (you can run first part as dsadm).
2. Make sure that no one is using DataStage.
3. Check if there are any processes left by executing the following commands:
4. Check if DataStage RPC Daemon (dsrpc) is running by executing:
5. Stop DataStage (you have to run this from $DSHOME)

How do I query a Datastage repository?

XMeta DB : Datastage Repository

1. Query to list Projects. SELECT *
2. List the folders within a project. SELECT *
3. Query to retrieve the DS JOB information. SELECT.
4. Query to list the jobs that are locked. SELECT.
5. Query to list the stages within the job.
6. Query to show the job details by folder.

How to schedule a job without any Schedule in DataStage director?

Jobs without any schedule in DataStage Director Schedule view are still run by Windows task scheduler. For example, if you schedule a job at Jan. 30 to be run once at 10 AM of next 10th of the month by selecting “Next” radio button in “Add to schedule” dialog box in DataStage Director

How do I view a job schedule in InfoSphere DataStage?

You can use one or more options from within InfoSphere DataStage to view details about a job schedule. You can schedule a job or job invocation. If you want to prevent a job from running at the scheduled time, you must unschedule it.

What is ‘queued’ state in DataStage director?

We know regular statuses that we observe in DataStage director. Sometimes when you trigger any datastage jobs, no job is running rather all triggered datastage jobs are going to “queued” state. One more uncommon status is ‘Queued’.

How to report an error for a specific job in DataStage?

The DataStage dsjob command reports error for a specific job, even if only requesting job info: dsjob -jobinfo projectname jobname ERROR: Failed to open job Status code = -1004