Table Schema: mf

This topic describes the columns in the mf_jobs table.

Column Name: The name of the column.
Data Type: The data type of the column.
Primary Key: The value is 1 if the column is part of the primary key; 0 if not.
Is Nullable: The value is 1 if the column can have a NULL value; 0 if not.
Column ID: The ID number of the column.
Comment: Text describing the column data (if available).
Reference Count: The number of other columns that have a foreign key pointing to this column. Only tables that exist in the reporting database are considered.
Reference To: The parent table and column (if there is an upward constraint). Only tables that exist in the reporting database are considered.

Column Name	Data Type	Primary Key	Is Nullable	Column ID	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

Table Schema: mf_jobs