FDB Scheduler

The FDB 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 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 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 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 (if certain criteria for auto add are met) or will place the Packaged Drug on the FDB Add list for NDF Managers to process.

FSS

This job will search the Federal Supply 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

This job will call the Standard Terminology Web Service 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 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 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 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 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.