Field Name	SQL Server Data Type	Example
	JobID	int (Identity)	1
	JobName	varchar(255)	Load authors
	SourceConnectionString	varchar(255)	Server=(local); Driver={SQL Server}; UID=sa; PWD=;Database=pubs
	SourceSelectSQL	text	select * from authors
	DestConnectionString	varchar(255)	DSN=Warehouse; UID=sa; PWD=; Database=DW1
	DestSelectSQL	text	tAuthors
	Preload	text	truncate table authors
	Postload	text	shellwait "c:\dw1\author_postload.exe"
	Comment	text	This example job entry for the DataPump object demonstrates some key features of the job table, such as support of DSN and DSN-less connection strings, multiple SQL statements in preload/postload, and shell/shellwait keywords to link to an external program.
	LastUpdate	datetime	Mar 1 1999 5:01PM

Table 2 Job Table Field Definition. Using these data types, you can implement this table in other platforms, such as Microsoft Access. The example illustrates what data is expected in each field.