Set Up Schedules for Batch Jobs Version

Contents

This topic discusses:

Links to related topics:

Search Online Doc
Current Release Notes

Overview

Activities such as generating reports and importing / exporting files are performed using batch processing. With batch processing, the system bundles data from files together and processes several bundles at a time. Batch jobs run in asynchronous mode. You establish a schedule for running your batch jobs and the system does the processing without user intervention.

All scheduled batch jobs are automatically set to a low priority so that interactive users do not have to compete with batch jobs for system time. You can also enable and disable scheduled jobs.

This topic describes how to use the Job Scheduler to set up schedules for batch jobs to run.

Security

The "ScheduleJobs" role object governs security for creating and editing batch job schedules. The default security level for "ScheduleJobs" is None.
Users who have job scheduling responsibility must have this role object included and set appropriately in their user profiles.

Alternately, you can use the scheduler if you have Administrator privileges in the system.

For details on working with user profiles, see Set Up and Maintain Users.

Also, a user can only set up scheduled jobs for the organizations specified in his/her data profile. A person creating scheduled jobs must also have the correct organization settings in his/her data profile to create jobs for the various organizations. See Set Up and Maintain Users for details.

Currently, you can assign schedules to these types of jobs, and others:

If you are using Sourcing and Contract Management, and wish to schedule contract price activation, see the subsequent section on Sourcing and Contract Management security.

Priority of Batch Jobs on Async Server

Batch jobs run on the async server according to different priority levels assigned in the system.

The Table of Priority Jobs displays these levels.

Document Retention Time

The system has retention times for various elements coded in an internal table. For example, the retention time for archived reports is 30 days. Reports older than 30 days are removed from the system every time the "purge" job runs. As explained in this topic, you can schedule the purge job to run as needed, for example, daily.

If a hospital wishes to keep reports longer than 30 days, the hospital needs to download the reports to a local network directory, where they can be accessed as needed. Table 1 shows retention times for other types of data that the system purges.

Table 1 - Retention Times for Data Elements

Type of Data

Retention Time
(days)

Reports

30

Patient ADT information for patients discharged more than five days previously

5

GL exports with a complete Status

60

Invoice exports with a complete Status

45

Par cart iPad imports with a complete Status 

45

Patient charge exports with a complete Status 

45

PO exports with a complete Status

45

Complete requisition imports

45

Advance replenishment exports with a Status of download complete

45

Confirmed pick lists

45

User Activity data

7

Processed EDI 810 data

30

To view the list of scheduled jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. A list appears showing you the job types and current schedules for running each type (Figure 1).

Figure 1 - Scheduled Jobs List

  1. To view the history of jobs that were run, for any of the jobs in the list, click History. A list showing jobs and the run Status of each appears (Figure 2). If any job had problems running, a link to error messages appears.

Figure 2 - History for a Scheduled Job

To enable/disable scheduled jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1)
  1. Scan the Job Desc field to locate the job whose schedule you wish to disable or enable.

  2. Click the edit icon or select Menu > Edit next to the Job Desc on any row.
    The Scheduled Jobs tabbed panel appears.

  3. To enable the job schedule, click the Enabled box. A check appears in the box. (See Figure 3).

Figure 3 - Enable (or Disable) a Scheduled Job

  1. To disable an enabled job schedule, click the Enabled box (which contains a check) (Figure 3, red arrow). The check disappears.

  2. If you are scheduling an export, you can enter characters in the File Name Prefix field (Figure 3, blue arrow) to have the system generate an export file that begins with the characters.

    Note: The fields on tabs under Job Parameters differ, depending on the type of scheduled job.
    Figure 3 displays Job Parameters for a GL Export.

  3. Click OK. You are returned to the Scheduled Jobs list. Click Refresh to view the change in the Enabled column.

To schedule General Ledger export jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).

Figure 4 - Create New Scheduled Job

  1. Enter a description for your general ledger export job (for example: "General Ledger Exports") in the Job Desc field.
  2. In the Job Name field, select GLExport.
  3. Click Next. The Scheduled Job Edit tabbed panels appear (Figure 5). (The fields on tabs under Job Parameters differ, depending on the type of scheduled job.)
    Figure 5 displays Job Parameters for a GL Export.

Figure 5 - Schedule a General Ledger Export Job

  1. Enter information in the Scheduled Job Edit tabbed panels as needed.

  2. Click Save.
  3. Click OK. You are returned to the Scheduled Jobs List.
  4. Click Refresh to see your new GL export job on the list of scheduled jobs.

Note: In addition to scheduling General Ledger transactions exports, you can generate General Ledger exports manually. To export GL information manually...

See Export General Ledger and Accounts Payable Transactions.

To schedule Accounts Payable export jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).
  3. Enter a description for your accounts payable export job (for example: "Accounts Payable Exports") in the Job Desc field.
  4. In the Job Name field, select AP Transactions Export.
  5. Click Next. The Scheduled Job Edit tabbed panels appear.
    The Scheduled Job Edit tabbed panels are similar to Figure 5, with one new field
    on the Job Parameters - General panel: External System (Figure 6).

Figure 6 - Job Parameters General Panel for an AP Transactions Export Job

  1. Follow the instructions in Steps 6 through 9 for General Ledger Exports to complete fields on the tabbed panels and schedule the job.
    (Note that different from General Ledger Exports, AP Exports uses no Transaction Category field.)

Note: In addition to scheduling Accounts Payable transactions exports, you can generate Accounts Payable exports manually. To export AP information manually...

See Export General Ledger and Accounts Payable Transactions.

To schedule item information export jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).
  3. Enter a description for your item export job (for example: "Item Exports") in the Job Desc field.
  4. In the Job Name field, select ItemExport.
  5. Click Next. The Scheduled Job Edit panel appears (Figure 7).

Figure 7 - Schedule an Item Information Export Job

  1. Enter information in the Scheduled Job Edit tabbed panels as needed.
  2. Click Save.
  3. Click OK. You are returned to the Scheduled Jobs List.
  4. Click Refresh to see your new item export job on the list of scheduled jobs.

Note: In addition to scheduling item information export jobs, you can generate item exports manually.
To export item information manually...

To schedule inventory activity batch jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your job in the Job Desc field.
  4. In the Job Name field, select Inventory Activity.
  5. Click Next. The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
    (The Job Parameters panel does not appear.)
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
    Click Help for information on the fields in the Scheduled Job and Job Frequency tabs.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new inventory activity job on the list of scheduled jobs.

To schedule invoice exports:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs.
    The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your invoice export job (for example: "Invoice Exports") in the Job Desc field.
  4. In the Job Name field, select Invoice Export.
  5. Click Next. The Scheduled Job Edit tabbed panels appear (similar to Figure 5).
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
    - Click Help for information on the fields in the Scheduled Job and Job Frequency tabs.

    - On the Job Parameters - General tabbed panel, enter
    Organization: The organization that owns the invoices for which you are creating the export schedule.

    Year Period Option
    : The period for the invoices to be included in the job.

    The choices are:
    Specified Period - invoices from the period you specify. If you select Specified Period, enter the period in the Period field.
    Current Period - The current period
    Prior Period - The previous period.

    Period and Accounting Year - The period and year for the invoices, according to your site's financial calendar.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new invoice export job on the list of scheduled jobs.

Note: In addition to scheduling invoice export jobs, you can perform invoice exports manually.
To export invoices manually...

To schedule export of patient charges:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1)
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your patient charge export job (for example: "Patient Charge Exports") in the Job Desc field.
  4. In the Job Name field, select Patient Charge Export.
  5. Click Next. The Scheduled Job Edit tabbed panels appear (similar to Figure 5).
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. Follow the instructions in Steps 6 through 9 for General Ledger exports to complete fields on the tabbed panels and schedule the job. (The Transaction Category field does not appear because it is not applicable for patient charges.)

Note: In addition to scheduling patient charge export jobs, you can perform patient charge exports manually.
To export patient charges manually...

For details, see To export patient charges manually.

To schedule purges:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your purge job (for example:"Weekly Purge Job") in the Job Desc field.
  4. In the Job Name field, select Purge Process.
  5. Click Next. The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
    (The Job Parameters panel does not appear.)
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
    Click Help for information on the fields.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs List.
  9. Click Refresh to see your new purge process job on the list of scheduled jobs.

Note: In addition to scheduling information purges, you can perform an information purge manually. The topic Periodic Maintenance Tasks-Purging Obsolete Information discusses how. To perform a manual purge...

To schedule backorder processing:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your backorder processing job in the Job Desc field.
  4. In the Job Name field, select Process Backorders.
  5. Click Next. The Scheduled Job Edit tabbed panels appear (Figure 5).
    (The Job Parameters panel only contains the fields Organization and Asset Location.)
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new backorder processing job on the list of scheduled jobs.

The topic: Release Backorders discusses the manual process of releasing backorders.

To schedule recurring invoice processing batch jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your job in the Job Desc field.
  4. In the Job Name field, select Process Recurring Invoices.
  5. Click Next. The Scheduled Job Edit, Job Frequency, and Job Parameters tabbed panels appear (similar to Figure 5).
  6. Enter or edit information in the tabbed panels as needed. On the Job Parameters panel, enter the Date that you want on the invoices to be processed, the Year and the Period. The Job Parameters panel also lets you specify the type of recurring invoices that you wish to process. The job will process recurring invoices that contain the attributes that you specify; for example, invoices with a specified Frequency. You may have set up several scheduled jobs to run for all of your different recurring invoice frequencies; e.g., for invoices that recur every month (specified in Frequency on the Job Parameters panel), create a scheduled job that runs monthly (specified in Frequency on the Job Frequency panel).
    Click Help for information on the fields in the Scheduled Job and Job Frequency tabs.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new job on the list of scheduled jobs.

To schedule processing of EDI 810 Invoice imports:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your EDI 810 job in the Job Desc field.
  4. In the Job Name field, select Process 810 Imports..
  5. Click Next. The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
    (The Job Parameters panel does not appear.)
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. Click Save.
  8. Click OK. You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new EDI 810 imports job on the list of scheduled jobs.

See Importing and Processing EDI 810 Invoice Files for details on processing EDI 810 files manually.

Auto-Authorize EDI, FAX, or email POs by Buy-From Location

This feature automatically authorizes POs for buy-from locations that use either the FAX, email, or EDI transmission method. To use this feature, you create one or more scheduled jobs that run the authorization.

Hospitals that use auto-authorization often find it efficient to create a daily scheduled job to run the authorization before the earliest vendor order cutoff time. You can schedule jobs for groups of vendors so that you process authorizations before any order cutoff times. You create a scheduled job, give it a Scheduled Job Group identifier that you have created in the Scheduled Jobs Group table. Then, you assign the identifier to one or more vendor buy-from locations, depending on the cutoff times you need to accommodate. Only POs from those locations are authorized at the scheduled time. You can create multiple Scheduled Job Groups and scheduled jobs.

If you wish, you can set a delay in the auto-authorization process. The delay lets you make any last minute changes to a PO before it is authorized -- such as a correction in a quantity or unit of measure. For example, in a job that runs hourly, a delay of thirty minutes would auto-authorize only those POs created more than a half hour before the next job run.

Automatic authorization works together with the Vendor Order Cycle established for a vendor buy-from location. For each purchase order to be automatically authorized, when the auto-authorization job runs, the system looks for a Vendor Order Cycle for the PO's buy-from location.

When you define a job for a Scheduled Job Group, and use an authorization delay, purchase orders that were recently created may not be authorized due to the “Delay Minutes” period. So, you need to be conscious of the vendor's cutoff time, and build in any authorization delay accordingly.

Security: To set up automatic authorization, you need permission established in your user profile for purchase order authorization and for scheduling jobs. You may also need permission to edit vendor records and tables.

The scheduled job setup steps are:

  1. Create the Scheduled Job Group identifier.
  2. Edit buy-from location records whose POs you wish to auto-authorize.
    - The PO Transmission Method must be FAX, Email, or EDI.
    Important: If EDI, Email or FAX is not selected, the system cannot auto-authorize POs for the buy-from location. In this situation, the system writes a System Note to the PO.
    - Select the corresponding Auto Authorize ... field.
    - On the buy-from locations' panels, assign a Scheduled Job Group identifier.
    You can leave the field blank, but to pick up POs for the buy-from location(s), you must also leave the field blank on the job scheduler.
  3. Create the scheduled job.
    - Assign the Scheduled Job Group identifier to the scheduled job. You can also add a Scheduled Job Group identifier to an existing job.

To define a Scheduled Job Group identifier,

  1. From the Materials Management main Contents, select Tables > Scheduled Job Groups.
  2. Click New (Figure 8).


    Figure 8 - List of Scheduled Job Groups Established for a Site

  3. A panel appears for creating a group (Figure 9).

Figure 9 - Creating a New Scheduled Job Group Identifier

  1. Enter an identifier for the Scheduled Job Group.
  2. Enter a Description for the group.
  3. Click Submit.
    The group identifier is available to use on scheduled jobs and buy-from locations.

To set up the the vendor buy-from location,

  1. From the main Materials or AP Contents, select Vendors > Vendors.
  2. Locate the vendor that you need.
  3. Select Menu > Buy From Locations.
  4. Locate the buy-from location of interest
  5. Next to the buy-from location name, click Menu > Edit, or click the pencil icon. The Buy From Location Edit panel appears (Figure 10).

Figure 10 - Vendor Buy-From Location Edit Panel

  1. Make sure that the PO Transmission Method is EDI, Email, or FAX.
  2. Select the box next to Auto Authorize... (EDI POs, Fax POs, Email POs), as appropriate for the PO Transmission Method.
  3. If you are using Scheduled Job Groups, click the prompt to assign a group to the buy-from location.
  4. Click Save.
  5. Click Submit.

To create a scheduled job for authorizing EDI, FAX, or email POs automatically

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs.
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).
  3. Enter a description for your job in the Job Desc field.
  4. In the Job Name field, select the appropriate job type -- one of the following:
    - Process Auto-Authorize EDI PO
    - Process Auto-Authorize FAX PO
    - Process Auto-Authorize Email PO.
  5. Click Next. The Scheduled Job Edit panel appears (Figure 11). This example is for Email POs. FAX and EDI POs are the same, except for the Job Type.

Figure 11 - Create and Schedule a Batch Job for Automatic EDI PO Authorization

  1. Enter information in the Scheduled Job Edit tabbed panels as needed.
  2. Click Save.
  3. Click OK.
    You are returned to the Scheduled Jobs list.
  4. Click Refresh to see your job appear on the list.

Mass Assignment of Items to Asset Locations

Mass assignment of items to asset locations can be performed manually or as a scheduled job. Once you have created and named an item assignment job (see Mass item assignments), you can schedule it to run, as described below.

To schedule mass item assignment jobs:

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job edit panel appears (Figure 4).
  3. Enter a description for your mass item assignment job in the Job Desc field.
  4. In the Job Name field, select Mass Item Assignment.
  5. Click Next. The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
    The Job Parameters panel contains only one field: Assignment Name.
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. Click Save.
  8. Click OK.
    You are returned to the Scheduled Jobs list.
  9. Click Refresh to see your new mass item assignment job on the list of scheduled jobs.

Scheduling a Report to Run

You can schedule running of reports defined in Reports > Report Definitions or reports that you have set up under Reports > My Report Definitions. A user does not need to be able to view reports in order to schedule report jobs.

  1. From the main Contents, click Reports > My Report Definitions or Reports > Report Definitions.
    The list of available report definitions appears (Figure 12).

Figure 12 - List of Report Definitions

  1. Next to the report definition for the report that you wish to run, click Menu > Job Scheduler.
    The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
    (The Job Parameters panel does not appear.)
    Note: The shortest time period for Daily Frequency is Every Day. If you need to run a report twice a day, set up two daily schedules for the report with different job descriptions and with different Start Time values.
  2. Enter information in the Scheduled Job Edit tabbed panels as needed.
    Click Help for information on the fields in the Scheduled Job and Job Frequency tabs.
  3. Click Save.
  4. Click OK. You are returned to the Report Definitions list.

Quick Release of Requisitions

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs.
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).
  3. Enter a description for your job in the Job Desc field.
  4. In the Job Name field, select Requisition Quick Release.
  5. Click Next. The Scheduled Job Edit tabbed panels appear.
    The top two Scheduled Job Edit tabbed panels are similar to Figure 5.
  6. On the Job Frequency tab, enter the Start Date and Start Time for running the quick release job. Use a 24-hour clock value when you enter data in these fields.
  7. Select the Frequency -- how often and when the job will run. Depending on the Frequency you select, other options appear. For example, if you select a Monthly Frequency, you can specify the day of the month to run the job, and the month(s) that you wish to run it.
  8. On the Job Parameters tab, enter the Organization and Asset Location whose requisitions you wish to release.
  9. Select/enter any further characteristics of the requisitions that you wish to release. The bottom tabs contain more selection options:

Pick Cycle Selections: you can specify up to five of your site's defined pick cycles that apply to requisitions for release.

Stat Selection: You can specify STAT requisitions for release.

From and To Selections:
- Department range: You can enter a range of department numbers using the From Department field for the first department in the range, and the To Department field for the last department in the range.
- Priority range: You can enter a range of priorities using the From Priority and To Priority fields.

Reason Code Selections: You can specify requisitions with particular Reason Codes in them. Up to four Reason Code choices are available.

  1. Click Save, Submit to complete set up of the scheduled job.

Warehouse Exports

Some sites choose to export documents such as picks from asset locations to an external distribution system. The ability to export data from an asset location is controlled by a field on the Asset Location record: Bypass Warehouse Export. This field is only relevant for sites that export warehouse data. When unchecked, warehouse export is available. When checked, the field turns off warehouse export. See "Data on the Asset Location Main Panel."

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs.
  2. Click New. The Create New Scheduled Job panel appears.
  3. Enter a description for your job in the Description field.
  4. In the Job Name field, select Warehouse Export.
  5. Click Next. The Scheduled Job Edit panel appears. The top two tabs are similar to Figure 11.
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. On the Job Frequency tab, enter the Start Date and Start Time for running the export job. Use a 24-hour clock value when you enter data in these fields.
  8. Select the Frequency -- how often and when the job will run. Depending on the Frequency you select, other options appear. For example, if you select a Monthly Frequency, you can specify the day of the month to run the job, and the month(s) that you wish to run it.
    The Job Parameters tab fields are not available, or relevant to this export. You can ignore them.
  9. Click Save, Submit to complete set up of the scheduled job.

GTIN Exports

The GTIN Export option within Imports/Exports & Financials is available to export GTIN data to external systems. The contents of the exported file are based on changes made to GTIN data only, and the export includes only those items that are accurately matched to GTIN data. If the system cannot match GTIN data to an actual item, then any unmatched rows of data are not exported.

The GTIN Export creates a comma delimited (CSV) file that includes all fields currently in the standard Item Export as well as these additional GTIN fields:

Parameters are available to define the export of all GTIN data, or GTIN data for a given date or timeframe. The primary export selection parameters include Organization, Asset Location, and Changed Date Option. The Changed Date Option is based on when changes or additions are made to any of the GTIN fields noted above

Setup procedures for GTIN exports are outlined in the topic "Export GTIN Data to an External File." You can create a scheduled job to do the export as follows.

  1. From the Work in Administration Contents, select Administration > Scheduled Jobs. The Scheduled Jobs list appears (Figure 1).
  2. Click New. The Create New Scheduled Job panel appears (Figure 4).
  3. Enter a description for your GTIN export job in the Job Desc field.
  4. In the Job Name field, select GTIN Export.
  5. Click Next. The Scheduled Job Edit panel appears. The top two tabs are similar to Figure 11.
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. On the Job Frequency tab, enter the Start Date and Start Time for running the export job. Use a 24-hour clock value when you enter data in these fields.
  8. Select the Frequency -- how often and when the job will run. Depending on the Frequency you select, other options appear. For example, if you select a Monthly Frequency, you can specify the day of the month to run the job, and the month(s) that you wish to run it.
    You can ignore the Job Parameters fields. These are not selectable.
  9. On the General tab, enter information as follows, as needed. These are the export fields:
Manufacturer ID

The ERP application's ID for the manufacturer.

Manufacturer Item No

The manufacturer's identifier for the item.

Identifier Number

The value of the GTIN or SSCC code assigned to the item.

Organization

The code and name for the organization that supplies the item.

Asset Location

The code for the item's supplying asset location.

Item Deleted Yes - selects deleted item information.
No - selects current item information.
Both - selects information for both current and deleted items.
Item Status Active - the item can currently be ordered/requisitioned.
Inactive - the item cannot currently be ordered/requisitioned.
Incomplete - the item is in the catalog, but there is not enough information about the item to requisition/order it.
Lowest UOM When checked, exports only the lowest unit of measure for the item.<br> Unchecked, all units of measure are exported. If an item has multiple GTIN&#8217;s for a UOM or Conversion Factor,<br> then the export will contain a row for each GTIN Item UOM/Conversion Factor match.
Changed Date Option Select the type of change date that you wish to use.
You can export on a given date or particular timeframe.
The Changed Date Options are:
- Specified Date
- Today
- Since Yesterday
- This Week
- Since Last Week
- This Month
- Since Last Month
- All* - Selects all GTIN data regardless of any changes. Your data profile determines which organizations and asset locations are available to you.

The Changed Date Option is based on when any changes or additions are made to any of the following GTIN fields:
- Manufacturer ID
- Manufacturer Item Number
- Unit of Measure
- Conversion Factor
- Identifier Type
- Identifier Number
Changed Date

Appears when the Changed Date option is Specified Date.
Select a date.

  1. Click Save, Submit to complete set up of the scheduled job.

Running a Scheduled Job Immediately

In some situations, you may wish to run a normally scheduled job outside of the schedule.

Figure 13 - Running an Enabled Scheduled Job At Will

On the Scheduled Jobs panel, the columns Running Now and Status indicate that a scheduled job is "running now" and its run status.
- When a job is running, the Running Now column displays Yes. This column can be sorted and filtered.
- The Status column indicates either "running" or "pending" for a job run that you have initiated.

The queue processor for scheduled jobs pick up and runs jobs initiated with the new Run Now command. These jobs may not start immediately, but will run with the next cycle of the queue monitor.

This feature is only available for core products administration (Materials Management, Accounts Payable, and General Ledger). Sourcing and Contract Management as a stand-alone product does not support this feature.

Scheduling Custom Exports

Custom exports are files that you create using report objects, such as Account Master, Contract Statistics, GL Ledger Transactions (and many others). Once created, the system exports the files using the Pulse appliance, set up to a export to a network location.

Creating a custom export is much like defining a report. You identify the fields for the export file, specify their order, identify any that are selection fields, and so on. Once you have configured the file, you can schedule generation and export of the file using the scheduler. The process is the same as scheduling other types of exports.

To schedule a custom export:

  1. From the main Contents, select Imports / Exports > Custom Exports.
    The list of custom exports appears (or No Data if none exist). See Figure 14.

Figure 14 - Schedule a Custom Export Job

  1. Next to the custom export that you wish to run, select Menu > Job Scheduler.
    The top two Scheduled Job Edit tabbed panels appear (similar to Figure 5).
  2. Enter information in the Scheduled Job Edit tabbed panels as needed.
    Click Help for information on the fields in the Scheduled Job and Job Frequency tabs.
  3. Click Save.
  4. Click OK. The Custom Exports list is re-displayed.

Setting Up Contract Price Activation Jobs in Sourcing and Contract Management

After importing a new contract (or an updated version of a current contract) into Sourcing and Contract Management and matching items, you select the item prices that you accept, and set a date when you wish to activate the prices. On the price activation date, the items are available for purchase on the contract.

Price activations run as scheduled jobs. You set up price activations in the Job Scheduler. You should set up price activation jobs to run at night, after midnight.

This topic describes how to use the Job Scheduler to set up price activation batch jobs.

Security for Scheduling Price Activation Jobs in Sourcing and Contract Management

Supply Chain users:

Your system administrator can adjust your user profile as needed.

To view the list of scheduled Price Activation jobs:

From the Administration Contents, select Scheduled Jobs. A list appears showing you the jobs and current schedules.

To disable or re-enable scheduled Price Activation jobs:

  1. From the Administration contents in Sourcing and Contract Management, select Admin > Scheduled Jobs.
    The list of jobs appears.
  2. Scan the Job Desc field to locate the job whose schedule you wish to disable or enable. The job name is Activate Contract Prices.
  3. Click the edit icon or select Menu > Edit next to the Job Desc.
    The Scheduled Jobs tabbed panel appears.
  4. To enable the job schedule, click the Enabled box. A check appears in the box.
  5. To disable an enabled job schedule, click the Enabled box (which contains a check). The check disappears.
  6. Click OK. You are returned to the Scheduled Jobs list. Click Refresh to view the change in the Enabled column.

To create a new scheduled price activation job:

  1. From the Administration contents in Sourcing and Contract Management, select Admin > Scheduled Jobs.
    The Scheduled Jobs list appears.
  2. Click New. The Create New Scheduled Job panel appears.
  3. Enter a description for the price activation job in the Job Desc field.
  4. In the Job Name field, click the prompt (...) and select Activate Contract Prices.
  5. Click Next.
  6. Enter information in the Scheduled Job Edit tabbed panels as needed.
  7. Click Save.
  8. Click OK. The Scheduled Jobs list is displayed. s
  9. Click Refresh to see the activation job on the list of scheduled jobs.
  10. To run the job, set the Enable field as described previously.

Approval Reminders and Approval Redirects

  1. Open the list of scheduled jobs (Miscellaneous Functions > Scheduled Jobs).
  2. Click New to create a new scheduled job.
  3. Enter header information (Figure 15) for the new approval reminder job.
    - Enter a job description (Job Desc).
    - Select the Job Name Approver Reminder and Redirect.

Figure 15 - Scheduled Job Header Panel

  1. Click Next. The Scheduled Job panel appears (Figure 16). This panel contains the setup fields for approval reminders.

Figure 16 - Scheduled Job Panel with Job Parameters Fields

  1. In the Job Frequency panel (Figure 16, blue box), enter values for the Start Date and other fields. The frequency of reminders sent is equal to the job frequency of the scheduled job.
  2. In the Job Parameters, General tab (Figure 16, red box), set up the reminders.

Organization - You can create an approval reminder job for any organization: select the organization. If you wish to set up the job for all organizations, leave this field blank.

Minimum hours to wait before 1st reminder - The number of hours that can elapse between an approval being required, and the first reminder notice being sent. In other words, when a user creates a requisition and sends it to approval, the requisition appears in an approver's queue. This field is the time interval (in hours) that must elapse before the approver gets a reminder message. Enter the number of hours.

Reminders to send before moving to next approver - An integer used with reminders in an approver group situation. This value is the number of reminder messages to be sent to a delinquent approver before redirecting to the next approver in the group. Enter an integer.

Approval Types - The types of documents for which the approval reminders are to be used. The options are: invoice, requisition, check request, or all types. Select an approval type.

Note: Be sure to enable the job. (Select the Enabled box.)

When an approver is delinquent in acting on approval queue entries, a formatted reminder message appears in his/her email. The message contains a count of each type of approval awaiting the user in the specified organization. The count includes entries that have been in the user's approval queue longer than the time frame defined in the scheduled job. The counts are broken down by approval type(s), as specified in the job. See Figure 16.

Tips in setting up reminders:

Details on using approval reminders are in the topic Approval reminders and redirected approvals