Technical Overview of J1 Client Application Services

The following steps provide an overview of how J1 Client Application Services manages scheduled processes and notifications.

Step 1

J1 Client Application Services calls the stored procedure named PROCESS_SCHEDULE$CHECK_STATUS every minute.

Step 2

The PROCESS_SCHEDULE$CHECK_STATUS stored procedure checks the PROCESS_SCHEDULE table for jobs to be run. If the stored procedure finds any processes that need to be run by the service, text from the COMMAND_LINE column of the PROCESS_SCHEDULE table is returned to J1 Client Application Services. The stored procedure also calculates and sets the next run date of the process and creates a row in the PROCESS_HIST table with a status of I (In Progress). If the stored procedure finds that a process was missed or needs to be skipped, it creates a row in the PROCESS_HIST table with a status of M (Missed) or S (Skipped). Information about missed or skipped processes is also returned to J1 Client Application Services.

Step 3

J1 Client Application Services executes the command line text returned from the stored procedure. The command line tells Windows to launch a J1 Desktop process (like Financial Aid Manager) and run the process. If the stored procedure returns information about a skipped or missed process, the Service writes notification information (if any) to various notification-related tables in J1.

Step 4

The process launched by J1 Client Application Services runs and writes status information to the J1 Desktop application log. If the job normally creates reports during processing, a snapshot of the reports is saved to the J1 database. The process updates the PROCESS_HIST table with a status of C (Completed) if it completed successfully or a status of E (Error) if it encountered any errors. The process also writes notification information (if any) to various notification-related tables in J1.

Step 5

If a machine is configured to send e-mail notifications, J1 Client Application Services checks the various notification-related tables in J1 Desktop for messages that need to be sent. If there are any e-mail notifications that need to be sent, the Service relays the message to the server defined in the SMTP Server Name column on the SMTP Relay Configuration window.