How do I use Command Line Options in MARS?

Command line switches are all optional, and it doesn't matter the order you put them in. Switches are separated by a semi colon (;).

Command Line Options

  • Command line switches are all optional, and it doesn't matter the order you put them in. Switches are separated by a semi colon (;).

When manually testing command line options, you must use an Elevated Command Prompt

MS Access: Using Command Line Options in MARS

Examples:

To execute a single schedule called "myschedule": mars.exe -s schedulename=myschedule
To do the above without any messages showing: mars.exe -s schedulename=myschedule;showmsg=no
To ignore the email address in the schedule and send to a specified email address: mars.exe -s schedulename=myschedul;showmsg=no;sendto=billt@mycompany.com
To send a package: mars.exe -p schedulename=mypackage;showmsg=no

Creating a schedule by command line:

  • Run mars.exe with the switch of -x e.g. \MARS\mars.exe -x
  • And then the following parameters:
ScheduleName : name of schedule
ReportPath : path of ms access report
FolderName : folder to store schedule
MARSUser :mars login userid
MARSPassword : mars login password
UserID : ms access report database userid
Password : ms access report database password
Frequency : schedule frequency {Daily,Weekly,Monthly,Yearly,Weekdays,Custom:[calendarname]}
RunAt : time schedule executes
Description : schedule description
Keyword : schedule keywords
StartDate :start date for schedule
EndDate : end date for schedule
Repeat : 1 or 0 if schedule is to repeat
RepeatInterval : repeat interval
RepeatUntil : repeat until time
Status : 1 or 0
UseLogin : 1or 0
UseSavedData : 1 or 0
Destination : schedule destination {Email,Disk,Fax,Printer,Ftp}
DestinationName : name of destination
SendTo : email send to or fax number
CC : email cc
Bcc : email bcc
Subject : email subject
Message : email message
Extras : extra attachments
MailFormat : text or html
SMTPServer : specify SMTP server
OutputPath : disk output path
FTPServer :
FTPUserName
FTPPassword
FTPPath
Format : schedule output format
Zip : 1 or 0
Embed : 1 or 0

Parameter: [parametername]:[parametervalue]

Separate out the switches using a semi-colon(;)

e.g. mars.exe -x schedulename:myschedule;reportpath:c:\myreports;foldername:Bills Reports

and so on.

Invoking MARS From Another Server

To invoke MARS from another server and/or run schedules with your own enterprise management or scheduling system, use

Windows:

PsExec: https://docs.microsoft.com/en-us/sysinternals/downloads/psexec

Linux:

Winexe: https://www.secpod.com/blog/winexe/