4 PLSQL job

This topic describes on creating PLSQL Jobs.

Scheduling EOD (End of Day)

Suppose we have created a new PLSQL job for EOD activity of FMG. Here it is a PLSQL job, where the procedure to be executed is pkgfmgEODBOD.spFmgEODBODScheduler.

Procedure Parameters need to be provided in Parameter Details.

Pre-EOD Event [BEPREEOD] is maintained to initiate End of Day.

Figure 4-1 Pre-EOD Event


Description of Figure 4-1 follows
Description of "Figure 4-1 Pre-EOD Event"

Scheduling BOD (Beginning of Day)

Suppose we have created a new PLSQL job for BOD activity of FMG. Here it is a PLSQL job, where the procedure to be executed is pkgfmgEODBOD.spFmgEODBODScheduler.

Parameters for this procedure need to be maintained in Parameter Details.

Example shows End of Day event [BE00003] to initiate Beginning Of Day.

Figure 4-2 End of Day event


Description of Figure 4-2 follows
Description of "Figure 4-2 End of Day event"