Working with Jobs

Create a Job

Delete a Job

Modifying a Job

Add a Transformation to a Job

Delete a Transformation from a Job

Add a Table to a Transformation

Delete a Table from a Transformation in the Process Flow Diagram

Delete a Table from the IT Data Marts Tree

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

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

Erase a Table from a Transformation

Purge a Table from a Transformation in the Process Flow Diagram

Purge a Table from the IT Data Marts Tree

Rename a Job

Create a Job

To create a job, perform the following steps:

From the menu bar of the SAS IT Resource Management client, select FileNewJob to open the New Job wizard.
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.
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.
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.

Note: If you are working in the IT Data Marts view and you have not selected a folder, but have referenced an IT data mart, then the job is created within the Contents subfolder of the last-referenced IT data mart. If you are working in the Folders view, the job is created in My Folders.

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.
  
  Tip
  You might want to create new subfolders to better organize the objects that you are creating. You can create these subfolders in the Contents folder within the IT data mart.
2. From the menu bar of the SAS IT Resource Management client, select FileNewFolder. The New Folder wizard appears.
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.
Note: In order for a new subfolder to be associated with an IT data mart, create it from the IT Data Marts tree in the SAS IT Resource Management client.
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 is displayed on the banner of the window.)
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:

Navigate to the location of the job in the IT Data Marts tree.
Right-click the job.
From the menu that is displayed, select Delete.
In the confirmation box, click Yes to delete the job.

Modifying a Job

Add a Transformation to a Job

Note: If you modify a job, you should redeploy it.

To add a transformation to a job, perform the following steps:

Navigate to the location of the job in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor window.
In the Transformations tree, expand the SAS IT Resource Management folder.
Drag and drop the transformation that you want to add to the job onto the process flow diagram.
Right-click the transformation to display a menu of options with which you can specify the transformation that you are adding to the job.
- For information about how to add a staging transformation, see Working with Staging Transformations.
- For information about how to add an Exception transformation, see Working with the Exception Transformation.
- For information about how to add an Aggregation transformation, see Preparing to Create an Aggregation Table .
- For information about how to add an Information Map transformation , see User-Specified Information Map Transformations.
- For information about how to add a Performance Report transformation, see the “Working with the Performance Report Transformation” topic in Chapter 8, “Working with Report Jobs and Performance Report Transformations,” in the SAS IT Resource Management 3.7: Reporting Guide.
Save the job that you modified. To do so, select FileSave.

Delete a Transformation from a Job

Note: If you modify a job, you should redeploy it.

To delete a transformation from a job, perform the following steps:

Navigate to the location of the job in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor.
Right-click the transformation that you want to delete.
Save the job that you modified. To do so, select FileSave.

Add a Table to a Transformation

Note: If you modify a job, you should redeploy it.

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:

Navigate to the location of the job in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor.
Right-click the transformation to which you want to add a target table. A menu of options is displayed in the Properties dialog box.
- The menu for a staging transformation provides an action to Add New Staged Table. For information, see Working with Staging Transformations.
- The menu for an Exception transformation provides an action to Add New Exception Tables. For information, see Working with the Exception Transformation.
- The menu for an Aggregation transformation provides an action to Add Aggregation Table. For information, see Preparing to Create an Aggregation Table .
Select the table that you want to add to invoke the wizard that generates the metadata for that table.
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.
Save the job that you modified. To do so, select FileSave.

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:

Navigate to the location of the job in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor.
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.
Save the job that you modified. To do so, select FileSave.

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, select Edit

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.

Note: Be sure to redeploy any jobs that reference the deleted table.

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:

Navigate to the folder that contains the table in the IT Data Marts tree.
Expand that folder and right-click the table that you want to delete.
From the menu that appears, select Delete.
In the confirmation box, click Yes,

CAUTION:

A job that accesses a table that is deleted cannot run successfully.

Note: Be sure to redeploy any jobs that reference the deleted table.

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:

Navigate to the folder that contains the table in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor.
Right-click the table whose contents and metadata you want to delete.
From the menu that is displayed, select Delete with Contents.

CAUTION:

A job that accesses a table that is deleted will not run successfully.

Note: Be sure to redeploy any jobs that reference the deleted table.

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

Navigate to the folder that contains the table in the IT Data Marts tree.
Expand that folder and right-click the table whose contents and metadata you want to delete.
From the menu that is displayed, select Delete with Contents.

CAUTION:

A job that accesses a table that is deleted will not run successfully.

Note: Be sure to redeploy any jobs that reference the deleted table.

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:

In the IT Data Marts tree, locate the table that you want to erase.
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.
Select Erase.
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. In addition, the jobs that used that table will fail due to a missing source table.

Note: Be sure to redeploy any jobs that reference the erased 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:

Navigate to the job that contains the table in the IT Data Marts tree.
Double-click the job to open it on the Diagram tab of the Job Editor.
Right-click the table whose contents you want to purge.
From the menu that is displayed, select Purge.
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:

Navigate to the folder that contains the table in the IT Data Marts tree.
Expand that folder and right-click the table that you want to purge.
From the menu that is displayed, select Purge.
In the confirmation box, click Yes.

Rename a Job

To rename a job, perform the following steps:

Navigate to the folder that contains the job in the IT Data Marts tree.
Right-click the job.
From the menu that is displayed, select Rename.
In the highlighted field, enter the new name of the job.