Skip to main content

Window: Scheduler

[Created: 19/02/2004 - Updated: 02/01/2000 ]
Description: Maintain Schedule Processes and Logs
Help: Schedule processes to be executed asynchronously

Tab: Schedule Process

[Created: 19/02/2004 - Updated: 02/01/2000 ]
Description: Schedule processes
Help: Schedule processes to be executed asynchronously
Tab Level: 0

Table 10: Schedule Process - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_scheduler.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_scheduler.AD_Org_ID numeric(10)
Table Direct
NameAlphanumeric identifier of the entityThe name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.ad_scheduler.Name character varying(60)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_scheduler.Description character varying(255)
String
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_scheduler.IsActive character(1)
Yes-No
ProcessProcess or ReportThe Process field identifies a unique Process or Report in the system.ad_scheduler.AD_Process_ID numeric(10)
Table Direct
Print FormatData Print FormatThe print format determines how data is rendered for print.ad_scheduler.AD_PrintFormat_ID numeric(10)
Table Direct
Report Output Typead_scheduler.ReportOutputType character varying(4)
List
Mail TemplateText templates for mailingsThe Mail Template indicates the mail template for return messages. Mail text can include variables. The priority of parsing is User/Contact, Business Partner and then the underlying business object (like Request, Dunning, Workflow object).So, @Name@ would resolve into the User name (if user is defined defined), then Business Partner name (if business partner is defined) and then the Name of the business object if it has a Name.For Multi-Lingual systems, the template is translated based on the Business Partner's language selection.ad_scheduler.R_MailText_ID numeric(10)
Table Direct
Schedulead_scheduler.AD_Schedule_ID numeric(10)
Table Direct
SupervisorSupervisor for this user/organization - used for escalation and approvalThe Supervisor indicates who will be used for forwarding and escalating issues for this user - or for approvals.ad_scheduler.Supervisor_ID numeric(10)
Table
Days to keep LogNumber of days to keep the log entriesOlder Log entries may be deletedad_scheduler.KeepLogDays numeric(10)
Integer
Date Last RunDate the process was last run.The Date Last Run indicates the last time that a process was run.ad_scheduler.DateLastRun timestamp with time zone
Timestamp With Time Zone
Date Next RunDate the process will run nextThe Date Next Run indicates the next time this process will run.ad_scheduler.DateNextRun timestamp with time zone
Timestamp With Time Zone
TableDatabase Table informationThe Database Table provides the information of the table definitionad_scheduler.AD_Table_ID numeric(10)
Table Direct
Record IDDirect internal record IDThe Record ID is the internal unique identifier of a record. Please note that zooming to the record may not be successful for Orders, Invoices and Shipment/Receipts as sometimes the Sales Order type is not known.ad_scheduler.Record_ID numeric(10)
Record ID

Tab: Parameter

[Created: 19/02/2004 - Updated: 02/01/2000 ]
Description: Scheduler Parameter
Help: Provide parameter for scheduled process
Tab Level: 1

Table 20: Parameter - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_scheduler_para.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_scheduler_para.AD_Org_ID numeric(10)
Table Direct
SchedulerSchedule ProcessesSchedule processes to be executed asynchronouslyad_scheduler_para.AD_Scheduler_ID numeric(10)
Table Direct
Process Parameterad_scheduler_para.AD_Process_Para_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_scheduler_para.IsActive character(1)
Yes-No
Default ParameterDefault value of the parameterThe default value can be a variable like @#Date@ad_scheduler_para.ParameterDefault character varying(255)
String
Default To ParameterDefault value of the to parameterThe default value can be a variable like @#Date@ad_scheduler_para.ParameterToDefault character varying(255)
String
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_scheduler_para.Description character varying(255)
String

Tab: Scheduler Recipient

[Created: 12/03/2004 - Updated: 02/01/2000 ]
Description: Recipient of the Scheduler Notification
Help: You can send the notifications to users or roles
Tab Level: 1

Table 30: Scheduler Recipient - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_schedulerrecipient.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_schedulerrecipient.AD_Org_ID numeric(10)
Table Direct
SchedulerSchedule ProcessesSchedule processes to be executed asynchronouslyad_schedulerrecipient.AD_Scheduler_ID numeric(10)
Table Direct
ActiveThe record is active in the systemThere are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.There are two reasons for de-activating and not deleting records:(1) The system requires the record for audit purposes.(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.ad_schedulerrecipient.IsActive character(1)
Yes-No
User/ContactUser within the system - Internal or Business Partner ContactThe User identifies a unique user in the system. This could be an internal user or a business partner contactad_schedulerrecipient.AD_User_ID numeric(10)
Search
RoleResponsibility RoleThe Role determines security and access a user who has this Role will have in the System.ad_schedulerrecipient.AD_Role_ID numeric(10)
Table Direct
Uploadad_schedulerrecipient.IsUpload character(1)
Yes-No
Authorization Accountad_schedulerrecipient.AD_AuthorizationAccount_ID numeric(10)
Table Direct
File NameName of the local file or URLName of a file in the local directory space - or URL (file://.., http://.., ftp://..)ad_schedulerrecipient.FileName character varying(255)
String

Tab: Log

[Created: 19/02/2004 - Updated: 02/01/2000 ]
Description: Scheduler Log
Help: Result of the execution of the Scheduler
Tab Level: 1

Table 40: Log - Fields

Table: Report Parameters

NameDescriptionHelpTechnical Info
TenantTenant for this installation.A Tenant is a company or a legal entity. You cannot share data between Tenants.ad_schedulerlog.AD_Client_ID numeric(10)
Table Direct
OrganizationOrganizational entity within tenantAn organization is a unit of your tenant or legal entity - examples are store, department. You can share data between organizations.ad_schedulerlog.AD_Org_ID numeric(10)
Table Direct
SchedulerSchedule ProcessesSchedule processes to be executed asynchronouslyad_schedulerlog.AD_Scheduler_ID numeric(10)
Table Direct
CreatedDate this record was createdThe Created field indicates the date that this record was created.ad_schedulerlog.Created timestamp without time zone
Date+Time
SummaryTextual summary of this requestThe Summary allows free form text entry of a recap of this request.ad_schedulerlog.Summary character varying(2000)
Text
ErrorAn Error occurred in the executionad_schedulerlog.IsError character(1)
Yes-No
ReferenceReference for this recordThe Reference displays the source document number.ad_schedulerlog.Reference character varying(60)
String
Text MessageText Messagead_schedulerlog.TextMsg character varying(2000)
Text
DescriptionOptional short description of the recordA description is limited to 255 characters.ad_schedulerlog.Description character varying(255)
String