How do I use "General" Custom Tasks in SQL-RD?

With General Tasks, you can perform basic tasks such as printing documents, waiting, or executing other schedules.

Custom Task - General

  • In the Schedule Wizard, go to Custom Tasks.
SSRS. Custom Tasks Wizard in Schedule in SQL-RD

General Tasks

SRRS. Custom Tasks: General in SQL-RD
  • With General Tasks, you can perform basic tasks such as printing documents, waiting, or executing other schedules.

Run Program/Open Document

General

SRRS. Custom Tasks: Open Document/Program in SQL-RD
  • Use this task to open a document or run a program or batch file.
  • Task Name: Enter a name for the task
  • Program/Document Path: Browse to find the path of the program or document
  • Working Folder: Browse to find the path of the working folder.
  • Optional Parameter: Enter any arguments or parameters
  • Windows Style: Choose from Normal, Minimized, Maximized or Hidden.
  • You can further instruct SQL-RD to wait for the program to exit or to stop waiting for the program after a specified amount of time.

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Print Document

General

SRRS. Custom Tasks: Print Document in SQL-RD
  • Use this task to print documents to a specified printer.
  • Task Name: Enter a name for the task
  • Printer Name: Select a printer or print driver from the list.
  • Click (+) button to browse for files to add to the printing list.
SRRS. Custom Tasks: Print Document in SQL-RD
  • Printer Name: Select a printer or print driver from the list.
  • Files: Use the (…) to browse for the file(s) to be printed
  • Recursive: Print all folder and/or documents in that path.

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Wait/Pause

General

SRRS. Custom Tasks: Wait/Pause in SQL-RD
  • Use this task to create pauses between tasks to ensure that one task is fully complete before the next task in the list is started.
  • Task Name: Enter a name for the task.
  • Select the pause interval to suit your requirements.

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Execute Schedule

General

SRRS. Custom Tasks: Execute Schedule in SQL-RD
  • This is a useful facility for "chaining" schedules together. Simply select the schedule you want to run from the list and click OK.
  • Task Name: Enter a name for the task.

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Send SMS

General

SRRS. Custom Tasks: Send SMS in SQL-RD

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.

Create Exchange Appointment

General

SRRS. Custom Tasks: Create Exchange Appointment in SQL-RD
  • Use this task to send a meeting request to one person or a group of people.
  • Task Name: Give the task a name.
  • Subject: Give the meeting request a title.
  • Location: Where is the meeting going to be.
  • Attendees: Enter the email address of required attendees, use inserts to enter email addresses or click on Attendees to being up different Address book options.
  • Start Time: Start time of the meeting.
  • End Time: End time of the meeting.
  • All Day Event: Check this if the meeting is to last all day.
  • Blank Space: Free type any additional information about the meeting here. You can use inserts to help compose the meeting request.
  • Reminder: Set a meeting reminder.
  • Importance: set an importance level to the meeting if required.
  • Files: Attach any files required for the meeting here, this may be reports etc.

Exchange Details

SRRS. Custom Tasks: Create Exchange Appointment in SQL-RD
  • You have the option to use the same email address as the one who is connected to the SQL-RD.

Options

SRRS. Custom Tasks: Options in SQL-RD
  • In this section, you have the option to run this task before, after or you can choose both the schedules executes.