Table Schema: mf_jobs

This topic describes the columns in the mf_jobs table.

Column Name Data Type Primary Key Is Nullable Column ID Comment Reference Count Reference To
job_guid uniqueidentifier 1 0 1   1  
company_guid uniqueidentifier 0 0 2   0 mf_companies.company_guid
catalog_guid uniqueidentifier 0 1 3   0 mf_catalogs.catalog_guid
site_guid uniqueidentifier 0 1 4   0 mf_sites.site_guid
user_guid uniqueidentifier 0 1 5   0 mf_users.user_guid
batch_guid uniqueidentifier 0 0 6   0  
attachment_guid uniqueidentifier 0 1 7   0  
set_guid uniqueidentifier 0 1 8   0  
output_attachment_guid uniqueidentifier 0 1 9   0  
job_type_id smallint 0 0 10   0 mf_job_types.job_type_id
job_data_format_id smallint 0 1 11   0 mf_job_data_formats.job_data_format_id
job_error_mode_type_id smallint 0 0 12   0  
job_id varchar (20) 0 1 13   0  
job_description varchar (50) 0 1 14   0  
job_process_object_id varchar (100) 0 1 15   0  
job_process_object_type varchar (100) 0 1 16   0  
job_process_object_configured bit 0 0 17   0  
job_date datetime 0 0 18   0  
job_start_date datetime 0 1 19   0  
job_next_run_date datetime 0 1 20   0  
job_last_run_date datetime 0 1 21   0  
job_master_schedule text 0 1 22   0  
job_schedule text 0 1 23   0  
job_process_data text 0 1 24   0  
job_package varchar (max) 0 1 25   0  
job_filter text 0 1 26   0  
job_data_compressed tinyint 0 0 27   0  
job_data_multifile tinyint 0 0 28   0  
job_foreach_catalog tinyint 0 0 29   0  
job_foreach_site tinyint 0 0 30   0  
job_notify_complete tinyint 0 0 31   0  
job_visible tinyint 0 0 32   0  
job_prepared tinyint 0 0 33   0  
job_running tinyint 0 0 34   0  
job_percent_complete tinyint 0 0 35   0  
job_server varchar (50) 0 1 36   0  
job_pid int 0 1 37   0  
job_alert tinyint 0 0 38   0  
job_suspend tinyint 0 0 39   0  
job_error tinyint 0 0 40   0  
job_closed tinyint 0 0 41   0  
lu_dt datetime 0 0 42   0  
cr_dt datetime 0 0 43   0  
lu_guid uniqueidentifier 0 1 44   0  
cr_guid uniqueidentifier 0 1 45   0  

Return to index of tables