How do I use Command Line Options in SQL-RD?

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

SSRS Reports: Using Command Line Options in SQL-RD.

Examples: 

Single Schedules and Data-Driven Schedules

  • To execute a Single Schedule and Data-Driven Schedules:

"C:\Program Files (x86)\ChristianSteven\SQLRD\sqlrd.exe" -s schedulename=myschedulename

  • To do the above without any messages showing:
sqlrd.exe -s schedulename:myschedule;showmsg=no
  • To ignore the email address in the schedule and send to a specified email address:

sqlrd.exe -s schedulename:myschedule;showmsg:no;sendto:billt@mycompany.com

Packages Schedules

  • To execute a Package:

"C:\Program Files (x86)\ChristianSteven\SQLRD\sqlrd.exe" -p schedulename=myschedulename

  • To do the above without any messages showing:

sqlrd.exe -p schedulename:myschedule;showmsg=no

  • To ignore the email address in the schedule and send to a specified email address:

sqlrd.exe -p schedulename:myschedule;showmsg:no;sendto:billt@mycompany.com

Event-Based Schedules

  • To execute an Event-Based Schedule: 

"C:\Program Files (x86)\ChristianSteven\SQLRD\sqlrd.exe" -e schedulename=myschedulename

  • To do the above without any messages showing:
sqlrd.exe -e schedulename:myschedule;showmsg=no
  • To ignore the email address in the schedule and send to a specified email address:

sqlrd.exe -e schedulename:myschedule;showmsg:no;sendto:billt@mycompany.com

Event-Based Packages: 

  • To execute an Event-Based Packages:

"C:\Program Files (x86)\ChristianSteven\SQLRD\sqlrd.exe" -ep schedulename=myschedulename

  • To do the above without any messages showing:
sqlrd.exe -ep schedulename:myschedule;showmsg=no
  • To ignore the email address in the schedule and send to a specified email address:

sqlrd.exe -ep schedulename:myschedule;showmsg:no;sendto:billt@mycompany.com

Automation Schedule:

  • To execute an Automation Schedule:

"C:\Program Files (x86)\ChristianSteven\SQLRD\sqlrd.exe" -a schedulename=myschedulename

  • To do the above without any messages showing:
sqlrd.exe -a schedulename:myschedule;showmsg=no
  • To ignore the email address in the schedule and send to a specified email address:

sqlrd.exe -a schedulename:myschedule;showmsg:no;sendto:billt@mycompany.com

Creating a schedule by command line:

Run sqlrd.exe with the switch of -x e.g. \SQLRD\sqlrd.exe -x

  • And then the following parameters:
ScheduleName : name of schedule
ReportPath : path of ssrs report
FolderName : folder to store schedule
SQLRDUser :sqlrd login userid
SQLRDPassword : sqlrd login password
UserID : ssrs report database userid
Password : ssrs 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. sqlrd.exe -x schedulename:myschedule;reportpath:c:\myreports;foldername:Bills Reports

and so on.

Invoking SQL-RD From Another Server

To invoke SQL-RD 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/