Working with Jobs

Create a Job

To create a job, perform the following steps:
  1. From the SAS Data Integration menu bar, select Filethen selectNewthen selectJob to open the New Job wizard.
  2. In Name field, you can override the default name that is assigned to the job. You can enter up to 60 characters in this field. A value is required in this field.
  3. In Description field, enter the information that describes the job. You can enter up to 200 characters in this field. A value is optional in this field.
  4. In Location field, you can override the default location of the job. To do so, click Browse to open the Select a Location dialog box where you can navigate to another location.
    Jobs must be created from within a folder in an IT data mart. If the New Job wizard is not invoked from within a folder in an IT data mart, SAS IT Resource Management creates a default folder (NewFolder) within the last referenced IT data mart. For information about how to create an IT data mart, see Create an IT Data Mart. To create a folder within an IT data mart, perform the following steps:
    Create a Folder
    1. Navigate to the IT data mart.
    2. From the SAS Data Integration menu, select Filethen selectNewthen selectFolder. The New Folder wizard opens.
    3. (Optional) Override the default name of the folder with a name that does not exceed 60 characters. A value is required in this field.
      Note: For best results, enter a name that indicates the purpose of the folder.
    4. (Optional) Enter a description of the folder. You can enter up to 200 characters. A value is optional in this field.
    5. (Optional) Override the default location by clicking Browse to open the Select a Location dialog box, where you can navigate to another location. A value is required in this field.
    6. Click OK to create the folder and store it in the IT data mart from which you invoked the New Folder wizard.
  5. Click OK to create the job and store it in the location that you chose.
    Note: The Diagram tab of the Job Editor window of SAS IT Resource Management automatically displays the job that you created. (The window is empty except for the job name that displays on the banner of the window.)
  6. To view the new job in the folder, click Refresh in the menu bar. (In order to activate the Refresh icon in the menu bar, click anywhere in the left panel of SAS IT Resource Management.)

Delete a Job

To delete a job, perform the following steps:
  1. Navigate to the location of the job in the IT Data Marts tree.
  2. Right-click the job.
  3. From the menu that is displayed, select Delete.
  4. In the confirmation box, click Yes to delete the job.

Modifying a Job

Add a Transformation to a Job

To add a transformation to a job, perform the following steps:
  1. Navigate to the location of the job in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor window.
  3. In the Transformations tree, expand the ITRM Transformations folder.
  4. Drag and drop the transformation that you want to add to the job onto the process flow diagram.
  5. Right-click the transformation to display a menu of options with which you can specify the transformation that you are adding to the job.
  6. Save the job that you modified. To do so, select Filethen selectSave.

Delete a Transformation from a Job

To delete a transformation from a job, perform the following steps:
  1. Navigate to the location of the job in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor.
  3. Right-click the transformation that you want to delete.
  4. Save the job that you modified. To do so, select Filethen selectSave.

Add a Table to a Transformation

You can add a table to a staging transformation or an Aggregation transformation. To add a table to a transformation in a job, perform the following steps:
  1. Navigate to the location of the job in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor.
  3. Right-click the transformation to which you want to add a target table. A menu of options is displayed.
  4. Select the table that you want to add to invoke the wizard that will generate the metadata for that table.
  5. The wizard prompts you for information that is required to specify the metadata for the table. When you are satisfied with your specifications, click Finish to generate the metadata for the table.
  6. Save the job that you modified. To do so, select Filethen selectSave.

Delete a Table from a Transformation in the Process Flow Diagram

To delete a table from a transformation in the process flow diagram, perform the following steps:
  1. Navigate to the location of the job in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor.
  3. Right-click the table that you want to delete. The table is removed from the transformation. However, the metadata of this table and its library are not deleted from the IT Data Marts tree, and its contents are not deleted from the physical file.
  4. Save the job that you modified. To do so, select Filethen selectSave.
If you delete the source table of an Aggregation transformation in the process flow diagram, the target tables of that transformation are also deleted. However, if this action is not acceptable, you can reinstate these tables. To do so, from the Edit menu, click Undo.
CAUTION:
To avoid processing errors, delete any reference to a deleted table, as a source or target for any transformation in any other job.
For example, Information Map transformations that use the deleted table as a source table should be deleted.

Delete a Table from the IT Data Marts Tree

The Delete action deletes the metadata for the table in the IT Data Marts tree. The physical table and the library are not deleted. To delete a table from the IT Data Marts tree, perform the following steps:
  1. Navigate to the folder that contains the table in the IT Data Marts tree.
  2. Expand that folder and right-click the table that you want to delete.
  3. From the menu that appears, select Delete.
  4. In the confirmation box, click Yes,
CAUTION:
A job that accesses a table that is deleted will not run successfully.

Delete a Table with Its Contents from a Transformation in the Process Flow Diagram

The Delete with Contents action deletes the metadata of the table and the physical table. It does not delete the associated library. To delete a table with its contents from the IT Data Marts tree, perform the following steps:
  1. Navigate to the folder that contains the table in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor.
  3. Right-click the table whose contents and metadata you want to delete.
  4. From the menu that displays, select Delete with Contents.
CAUTION:
A job that accesses a table that is deleted will not run successfully.

Delete a Table with Its Contents from the IT Data Marts Tree

The Delete with Contents action deletes the metadata of the table and the physical table. It does not delete the associated library. To delete a table with its contents from the IT Data Marts tree, perform the following steps:
  1. Navigate to the folder that contains the table in the IT Data Marts tree.
  2. Expand that folder and right-click the table whose contents and metadata you want to delete.
  3. From the menu that displays, select Delete with Contents.
CAUTION:
A job that accesses a table that is deleted will not run successfully.

Erase a Table from a Transformation

Erasing a table deletes the physical table, its contents, and its metadata. To erase a table, perform the following steps:
  1. In a tree view of SAS IT Resource Management, locate the table that you want to erase.
  2. Right-click the table that you want to erase. The job that uses the table must be closed and currently not in use before erasing.
  3. Select Erase.
  4. Click Yes to confirm that you want to erase this table.
CAUTION:
If you erase a table that serves as a source table in other jobs, then these associated jobs might not execute because they are missing a source table.
Simply erasing a table does not affect the metadata of the associated jobs. However, if you erase a table and then rerun the job that creates that table, then the data for the deleted table is not created and the jobs that used that table will fail due to a missing source table.

Purge a Table from a Transformation in the Process Flow Diagram

The Purge action removes all observations from physical tables but leaves the physical table structure intact. To purge a table from the process flow diagram, perform the following steps:
  1. Navigate to the job that contains the table in the IT Data Marts tree.
  2. Double-click the job to open it on the Diagram tab of the Job Editor.
  3. Right-click the table whose contents you want to purge.
  4. From the menu that displays, select Purge.
  5. In the confirmation box, click Yes.

Purge a Table from the IT Data Marts Tree

The Purge action removes all observations from physical tables but leaves the physical table structure intact. To purge a table from the IT Data Marts tree, perform the following steps:
  1. Navigate to the folder that contains the table in the IT Data Marts tree.
  2. Expand that folder and right-click the table that you want to purge.
  3. From the menu that displays, select Purge.
  4. In the confirmation box, click Yes.

Rename a Job

To rename a job, perform the following steps:
  1. Navigate to the folder that contains the job in the IT Data Marts tree.
  2. Right-click the job.
  3. From the menu that displays, select Rename.
  4. In the highlighted field, enter the new name of the job.