Lock Resources

Lock Resources represent physical or logical devices, such as files, disk drives, tables, and databases. You can define Lock Resources in job definitions, as described in Prerequisites, or with the Lock Resource tool, which enables you monitor jobs that are currently waiting for and utilizing Lock Resources.

There are two types of Lock Resources, as follows:

Exclusive Lock Resources: Prevent other jobs from concurrently executing.
Shared Lock Resources: Enable other jobs to concurrently execute.

A SMART folder contains three jobs, as follows:

Update_USA: Exclusive access is granted to the Update_Finance file Lock Resource.
Update_EU:
Update_AUS

Update_EU and Update_AUS cannot execute when Update_USA executes.

Lock Resources created in the Lock Resources tool must be manually released and deleted after the jobs that require them complete execution. This releases them to jobs that are Waiting for these resources before they can begin execution. Resources that are defined in job definitions are automatically deleted and released.
Jobs that are defined as Critical, and that are Waiting an exclusive Lock Resource execute before jobs defined as Priority.

If a Critical job is waiting for an exclusive Lock Resource and is defined with a low Priority, this job executes before a non-Critical job defined with a high Priority.
If two jobs are waiting for an exclusive Lock Resource and both are defined as Critical, the job with the higher Priority executes first.

The following video describes Lock Resources:

Lock Resources List

The following table describes the Lock Resources list.

Attribute	Description
Resource Name	Defines the name of the Lock Resource that is currently held.
Type	Defines the type of Lock Resource, as follows: Shared: Jobs that are defined with the same Lock Resource can run concurrently. Exclusive: Jobs that are defined with the same Lock Resource cannot run concurrently.
Jobs Using	Defines the number of jobs currently using the Lock Resource.
Jobs Requesting	Defines the number of jobs requesting a Lock Resource.
Resource Added	Determines where the Lock Resource is held, as follows: Manually: Indicates that the Lock Resource is held manually in the Lock Resources tool. By Job/SMART Folder: Indicates that the Lock Resource is held by a SMART folder, sub-folder, or job, as defined in the definition.

Resource Usage List

The following table describes the Resource Usage list.

Attribute	Description
Job Name	Defines the job name.
Run ID	Defines the unique code that identifies the job run.
Resource State	Determines one of the following job Lock Resource states: Exclusive: The job is currently holding the Lock Resource, which prevents all other jobs that require the exclusive or shared Lock Resource from running. Exclusive - Manually: The Lock Resource is held manually from the Lock Resources tool, which prevents all other jobs that require the exclusive or shared Lock Resource from running. Shared: The job is currently holding the Lock Resource, which prevents all other jobs that require the shared Lock Resource in exclusive mode from running. Shared - Manually: The Lock Resource is held manually from the Lock Resources tool, which prevents all other jobs that require the shared Lock Resource in exclusive mode from running. Requested: The job has requested the Lock Resource, as described in Job General Attributes. Waiting: The job is currently waiting for the Lock Resource.
File Name	Defines the filename that the job executes.