## FDB Scheduler

The FDB
First DataBank Scheduler is used to schedule when the five background tasks will be executed. Each of these tasks executes independently. For performance reasons the tasks should be scheduled to run during the systems ‘down’ time and should be spaced out so they do not run at the same time. Generally each task will run in less than five minutes so they don’t need to be spread out significantly. Only the PPS-N Supervisor can see this screen.

Jobs Types | Description
Inactivation Job | This job looks at the Product and NDC National Drug Code proposed inactivation date. If there are any NDCs that are Active and have a proposed Inactivation date earlier than the current date then the NDC will be inactivated. If there are any Products that are Active and have a proposed Inactivation date earlier than the current date then a Request A user action that a PEPS Item (OI, Product Item, or NDC Item) addition or modification be considered by the PNM for updates within the PEPS enterprise database. to Inactivate the product will be put on the request list.
Fdb Update | This job will search the FDB Packaged Drugs Update Date field for all entries greater that the Last Successful Run date. When a match is found, the system will check the FDB Drug against its VA Department of Veterans Affairs equivalent to see if any fields that are currently monitored by the VA were updated. If so, then the job will put an entry on either the FDB Update list (if the system could not automatically process the update) or the Update Report (if the system automatically processed the update.
Fdb Add | This job will search the FDB Packaged Drugs Add Date field for all entries greater that the Last Successful Run date. When a match is found, the system will either add the Packaged Drug to the PPS-N EPL Enterprise Product List (if certain criteria for auto add are met) or will place the Packaged Drug on the FDB Add list for NDF National Drug File Managers to process.
FSS Federal Supply Schedule | This job will search the Federal Supply Schedule The frequency by which the doses are to be administered (i.e., Q8H, BID, NOW). Often referred to as Administration Schedule. database for any updates that have occurred since the Last Success Run time. Any PPS-N EPL NDCs that have corresponding updates in FSS will be automatically updated.
STS Standards and Terminology Services | This job will call the Standard Terminology Web Service A logical grouping of capabilities that support a common business process. Thus a “drug information service” might provide capabilities that allow for the searching of different types of drug information and different types of searches for the same information (i.e., searching for a drug by Generic Name, NDC, Therapeutic category). This is loosely analogous to the class-method relationship, in which a class is composed of multiple methods that support the usage of the class. to retrieve the up to date list of Standard Medication Routes. Any newly added routes will be added to the PPS-N EPL.

#### FDB Control Process

Refresh button: This button refreshes the System Time field and the information in the table.

System Time: This is the current date time of the Application
A software product that provides a specified functionality. Server that will be processing the request. It may very well be in a different time zone that the client machine where the user is located.

Scheduler Status: This should always be RUNNING. If this field is set to anything other than running then a serious error has occurred and the System Administrators should be notified.

#### Table Columns

· Jobs: The name of the job.

· Controls:

o Resume: This button allows for the control process to be restarted if it was paused for some reason.

o Pause: This button will stop the job from executing at the specified time and put the job in a hold mode.

o Schedule: This button will allow the user the schedule the job to run once they have set the Hours and Minutes.

· Hrs: This is the server time hours for the job to run. For example, selecting 1 would have the job run in the 1AM hour. Used in conjunction with the Mins column.

· Mins: This is the server time minutes for the job to run. For example, selecting 30 would have the job run at the bottom of the hour. Used in conjunction with the Hrs column.

· Job Status: PAUSED indicates that the job is not current scheduled to run. RUNNING indicates the job will run at the Next Fire Time.

· Next Fire Time: This is the next time schedule for the job to execute.

· Last Success Run: For the Inactivation Job, FSS and STS jobs, this indicates the date time the job finished on its last run. For the FDB Add and Update jobs, this indicates the latest value in the AddDate or UpdateDate field in the FDB Packaged Drug table.

· Process
A process is a collection of activities that takes one or more kinds of input and creates an output that is of value to the customer. It is cross-functional and results oriented, defying rather than respecting organizational boundaries. It is focused on goals and ends rather than actions and means. Thinking about the process is a prerequisite to re-engineering; only processes can be re-engineered. Status:

o STOPPED indicates the job has not been executed since the code was deployed. COMPLETED indicates that the job has executed and the Last success Run will hold the time the job last completed.

o RUNNING indicates the job is currently executing.

Under the jobs table there is a row of National setting variables that are used in the execution of the product.

Jobs Types | Description
Messaging Status | On indicates Messages are being sent to NDF as they are generated. Off indicates Messages are being queued as they are generated. When the NDF Supervisor changes the status from Off to On all queued messages will be sent.
Fda Host Name | This is the host name for the FDA Food and Drug Administration Server which holds the FDB Med guides. This is used in conjunction with the name of the med guide in the product attribute to display the med guide.
Messages on Queue | This is an integer count of the number of messages on the NDF message queue.
Messaging Running | This is used in conjunction with the Message A collection of data in a standardized format that can be sent to or received at a given destination. Status button. When the messaging is on, this is set to true, when the messaging is off, this is set to false.
Error Messages | If an error occurs when processing the NDF Messages from the queue, the error will be displayed here and the messaging will automatically be turned back off.