The following steps provide an overview of how J1 Client Application Services manages scheduled processes and notifications.
J1 Client Application Services calls the stored procedure named PROCESS_SCHEDULE$CHECK_STATUS every minute.
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.
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.
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.
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.