At my version of NBU 7.6, this is file 857.dat from a NBDB unload.
"JOBD_MAIN"."JOBD_Job"
It's a bit difficult to read ... (this is just x1 row)
'1000002','194','0','20126','0','0','17','0','0','','0','','','','root','','','','','','','','','0','0','0','85000','0','0','1','3','1','1','0','0','0','0','0','0','','0','0','0','1','0','0','0','0','-1','','','','','0','0','0','0','','','','0','',0xC50243001C04020100800000,'2013-11-19 00:56:21.000000','2013-11-19 00:56:37.000000','2013-11-19 00:56:21.000000','2013-11-20 00:00:03.293983'
The fileds are defined (so 1000002 is master server key, 194 is jobid and so on ...)
1 "MasterServerKey" unsigned int NOT NULL CONSTRAINT "CKC_MASTERSERVERKEY_JOBD_JOB" check(MasterServerKey between 1000001 and 2000000)
2 ,"JobId" integer NOT NULL DEFAULT autoincrement CONSTRAINT "CKC_JOBID_JOBD_JOB" check(JobId >= 1)
3 ,"ParentJobId" integer NOT NULL DEFAULT 0
4 ,"ActiveProcessId" integer NOT NULL DEFAULT 0
5 ,"MainProcessId" integer NOT NULL DEFAULT 0
6 ,"ProductType" integer NOT NULL DEFAULT 0
7 ,"JobType" integer NOT NULL
8 ,"JobSubType" integer NOT NULL
9 ,"PolicyType" integer NOT NULL DEFAULT 0
10 ,"PolicyName" varchar(256) NOT NULL DEFAULT ''
11 ,"ScheduleType" integer NOT NULL DEFAULT 0
12 ,"ScheduleName" varchar(256) NOT NULL DEFAULT ''
13 ,"ClientName" varchar(1024) NOT NULL DEFAULT ''
14 ,"ControlHost" varchar(1024) NOT NULL DEFAULT ''
15 ,"JobOwner" varchar(32) NOT NULL DEFAULT 'root'
16 ,"JobGroup" varchar(32) NOT NULL DEFAULT 'root'
17 ,"BackupId" varchar(256) NOT NULL DEFAULT ''
18 ,"SourceMediaId" varchar(32) NOT NULL DEFAULT ''
19 ,"SourceStorageUnitName" varchar(128) NOT NULL DEFAULT ''
20 ,"SourceMediaServerName" varchar(1024) NOT NULL DEFAULT ''
21 ,"DestinationMediaId" varchar(32) NOT NULL DEFAULT ''
22 ,"DestinationStorageUnitName" varchar(128) NOT NULL DEFAULT ''
23 ,"DestinationMediaServerName" varchar(1024) NOT NULL DEFAULT ''
24 ,"DataMovement" integer NOT NULL DEFAULT 0
25 ,"StreamNumber" integer NOT NULL DEFAULT 0
26 ,"CopyNumber" integer NOT NULL DEFAULT 0
27 ,"Priority" integer NOT NULL DEFAULT 0
28 ,"Retention" integer NOT NULL DEFAULT 0
29 ,"Compression" integer NOT NULL DEFAULT 0
30 ,"Status" integer NOT NULL DEFAULT 0
31 ,"State" integer NOT NULL DEFAULT 0
32 ,"Done" integer NOT NULL DEFAULT 0
33 ,"Try" integer NOT NULL DEFAULT 0
34 ,"NumberOfFiles" unsigned int NOT NULL DEFAULT 0
35 ,"EstimatedFiles" unsigned int NOT NULL DEFAULT 0
36 ,"KilobytesTransfered" unsigned bigint NOT NULL DEFAULT 0
37 ,"KilobytesToTransfer" unsigned bigint NOT NULL DEFAULT 0
38 ,"TransferRate" unsigned int NOT NULL DEFAULT 0
39 ,"PercentComplete" integer NOT NULL DEFAULT 0
40 ,"CurrentFile" varchar(1024) NOT NULL DEFAULT ''
41 ,"Restartable" integer NOT NULL DEFAULT 0
42 ,"Suspendable" integer NOT NULL DEFAULT 0
43 ,"Resumable" integer NOT NULL DEFAULT 0
44 ,"Killable" integer NOT NULL DEFAULT 0
45 ,"FrozenImage" integer NOT NULL DEFAULT 0
46 ,"TransportType" integer NOT NULL DEFAULT 0
47 ,"DedupRatio" float NOT NULL DEFAULT 0
48 ,"CurrentOperation" integer NOT NULL DEFAULT 0
49 ,"QReasonCode" integer NOT NULL DEFAULT 0
50 ,"QResource" varchar(1024) NOT NULL DEFAULT ''
51 ,"RobotName" varchar(256) NOT NULL DEFAULT ''
52 ,"VaultName" varchar(256) NOT NULL DEFAULT ''
53 ,"ProfileName" varchar(256) NOT NULL DEFAULT ''
54 ,"SessionId" integer NOT NULL DEFAULT 0
55 ,"NumberOfTapeToEject" integer NOT NULL DEFAULT 0
56 ,"SubmissionType" integer NOT NULL DEFAULT 0
57 ,"AcceleratorOptimization" integer NOT NULL DEFAULT 0
58 ,"InstanceDatabaseName" varchar(1024) NULL
59 ,"AuditUserName" varchar(128) NOT NULL DEFAULT ''
60 ,"AuditDomainName" varchar(256) NOT NULL DEFAULT ''
61 ,"AuditDomainType" integer NOT NULL DEFAULT 0
62 ,"RestoreBackupIDs" varchar(1024) NOT NULL DEFAULT ''
63 ,"BitField" binary(12) NOT NULL DEFAULT 0
64 ,"StartTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'
65 ,"EndTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'
66 ,"ActiveTryStartTime" timestamp NOT NULL DEFAULT '1970-01-01 00:00:00'
67 ,"LastUpdateTime" timestamp NOT NULL DEFAULT utc timestamp
68 ,CONSTRAINT "PK_JOBD_JOB" PRIMARY KEY CLUSTERED ("MasterServerKey" ASC,"JobId" ASC)
Or in a easier format ...
---< Row 1 >---------------------------------------------------------------
1: "MasterServerKey" unsigned int = '1000002'
2: "JobId" integer = '194'
3: "ParentJobId" integer = '0'
4: "ActiveProcessId" integer = '20126'
5: "MainProcessId" integer = '0'
6: "ProductType" integer = '0'
7: "JobType" integer = '17'
8: "JobSubType" integer = '0'
9: "PolicyType" integer = '0'
10: "PolicyName" varchar(256) = ''
11: "ScheduleType" integer = '0'
12: "ScheduleName" varchar(256) = ''
13: "ClientName" varchar(1024) = ''
14: "ControlHost" varchar(1024) = ''
15: "JobOwner" varchar(32) = 'root'
16: "JobGroup" varchar(32) = ''
17: "BackupId" varchar(256) = ''
18: "SourceMediaId" varchar(32) = ''
19: "SourceStorageUnitName" varchar(128) = ''
20: "SourceMediaServerName" varchar(1024) = ''
21: "DestinationMediaId" varchar(32) = ''
22: "DestinationStorageUnitName" varchar(128) = ''
23: "DestinationMediaServerName" varchar(1024) = ''
24: "DataMovement" integer = '0'
25: "StreamNumber" integer = '0'
26: "CopyNumber" integer = '0'
27: "Priority" integer = '85000'
28: "Retention" integer = '0'
29: "Compression" integer = '0'
30: "Status" integer = '1'
31: "State" integer = '3'
32: "Done" integer = '1'
33: "Try" integer = '1'
34: "NumberOfFiles" unsigned int = '0'
35: "EstimatedFiles" unsigned int = '0'
36: "KilobytesTransfered" unsigned bigint = '0'
37: "KilobytesToTransfer" unsigned bigint = '0'
38: "TransferRate" unsigned int = '0'
39: "PercentComplete" integer = '0'
40: "CurrentFile" varchar(1024) = ''
41: "Restartable" integer = '0'
42: "Suspendable" integer = '0'
43: "Resumable" integer = '0'
44: "Killable" integer = '1'
45: "FrozenImage" integer = '0'
46: "TransportType" integer = '0'
47: "DedupRatio" float = '0'
48: "CurrentOperation" integer = '0'
49: "QReasonCode" integer = '-1'
50: "QResource" varchar(1024) = ''
51: "RobotName" varchar(256) = ''
52: "VaultName" varchar(256) = ''
53: "ProfileName" varchar(256) = ''
54: "SessionId" integer = '0'
55: "NumberOfTapeToEject" integer = '0'
56: "SubmissionType" integer = '0'
57: "AcceleratorOptimization" integer = '0'
58: "InstanceDatabaseName" varchar(1024) = ''
59: "AuditUserName" varchar(128) = ''
60: "AuditDomainName" varchar(256) = ''
61: "AuditDomainType" integer = '0'
62: "RestoreBackupIDs" varchar(1024) = ''
63: "BitField" binary(12) = 0xC50243001C04020100800000
64: "StartTime" timestamp = '2013-11-19 00:56:21.000000'
65: "EndTime" timestamp = '2013-11-19 00:56:37.000000'
66: "ActiveTryStartTime" timestamp = '2013-11-19 00:56:21.000000'
67: "LastUpdateTime" timestamp = '2013-11-20 00:00:03.293983'