Table sem5.dbo.SEM_JOB
Keeps job name for Command process

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
COMMAND_ID char 32
USN bigint 8 Update serial number; used by replication
COMMAND_NAME varchar 64 Hard-coded English string that indicates which command was launched. This is the same string as what is placed in the XML for pre-defined name.

Update_Now = Update Content
ScanNow_Full = Full Scan
ScanNow_Quick = Active Scan
ScanNow_Custom = Custom Scan
Update_ScanNow_Full = Update Content and Scan Full
Update_ScanNow_Quick = Update Content and Scan Quick
Update_ScanNow_Custom = Update Content and Scan Custom
CancelScan = Cancel Scan
Reboot = Restart
ApOn = Turn Auto-Protect On
ApOff = Turn Auto-Protect Off
FwOn = Turn Firewall On
FwOff = Turn Firewall Off
DeleteQuarantine = Delete from Quarantine
COMMAND_DESC nvarchar 700  √  null Detail description of the command
SOURCE_SITE_ID char 32 GUID of the site from where the command generated
SOURCE_ADMIN_ID char 32 GUID of the administrator who issued the command
CREATE_TIME bigint 8 When the command was issued at the console by the administrator
TIME_STAMP bigint 8 The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 Deleted row:
1 = Deleted
0 = Not Deleted
SOURCE_TYPE tinyint 1 ((0))
SOURCE_HOST_IP varchar 256  √  null
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 varchar 260  √  null
RESERVED_BINARY varbinary 1000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
COMMAND_ID Primary key Asc PK_SEM_JOB