; Note: comment lines in .INI files always start with a semicolon

[Template]
Description=Use this template to create a job that will export data from a database table or view to a tab-separated file.

[Variables]
; Key values that have their name enclosed in % signs will be used for 
; template wizard questionnaire and substitution variables
; such key values should consist of 2 comma separated parts:
;    1. Field Edit Style (EDIT, YES/NO, FILE BROWSE, 
;                         DIR BROWSE, PROCESS BROWSE,
;                         FTP BROWSE, MAIL PROFILE LIST,
;                         REMOTE FILE BROWSE, REMOTE DIR BROWSE,
;                         REMOTE AGENT LIST, DB PROFILE LIST)
;    2. Prompt
;
; Example: %VAR%=EDIT,What is the name of the service that you want to monitor?
;
; Key values that don't have their name enclosed in % signs will be used for 
; job properties (See online help on "Job property names for use with JDL command" 
; topic for more details).
;
; Example: DAY_NUMBER=1

%DB_PROFILE%=DB PROFILE LIST,From which database do you want to import data?
%TABLE%=EDIT,Which database table or view do you want to use as a data source?
%FILE%=FILE BROWSE,Into which file do you want to write the data:
%RECIPIENT%=EDIT,To whom do you want to sent the email alert when the export fail?
%EMAIL_PROFILE%=MAIL PROFILE LIST,If you use MAPI email interface, then which email profile do you want to use? If you use Lotus Notes or SMTP email interfaces, enter User ID required for logging to your email system.
%EMAIL_PASSWORD%=EDIT,If you are required to login to your email system, what is your password?
JOB_TYPE=S
SCHEDULE_TYPE=D
START_TIME=2:00
ASYNC=Y
SKIP=N
RETRY_ON_ERROR=Y
RETRY_INTERVAL=600
NUMBER_OF_RETRIES=2
MSG_ERROR=Y
MSG_EMAIL=Y
MSG_ACCOUNT=%EMAIL_PROFILE%
MSG_PASSWORD=%EMAIL_PASSWORD%
MSG_RECIPIENT=%RECIPIENT%
DESCRIPTION=This job imports tab-separated files into database. It will send an email alert to the specified recipient if import fails.

; Notes: The script bellow can include substitution variables.
;        Substitution variables must be specified in %VAR% format 
;        where VAR is the variable name.
;
; Everything after the next line will be used for the template script.
;========================================================================================
[Body]

Dim rows, number
Dim message, string


// Connect to database
DatabaseConnect "%DB_PROFILE%"
// Export file
DatabaseImport "%TABLE%", "%FILE%", rows
// Disconnect from database
DatabaseDisconnect

// send notification
ConcatEx, rows, " rows exported into file \"%FILE%\" from %TABLE% (%DB_PROFILE%)", message
MailSend "%EMAIL_PROFILE%", "%EMAIL_PASSWORD%", "%RECIPIENT%", "Export Status", message