A schedule runs a single job. Run as many schedules as you need. Schedule every day, once a day or any combination of days. Run from every minute to once a day or any interval in between or even run continously.
A job is a series of tasks or steps. Each step can have an input and/or output. If an error occurs such as a database is down then run another job to handle that problem.
Pickup files from a local or network drive. Convert files from one format to another. Copy files to another location.
Transfer files to a remote FTP site. Retrieve files from a remote FTP site and then run operations on those files such as file conversion or inserting data into a database.
Run any SQL statement. Run database queries and return the data as XML for the next step. Insert data into the database and run stored procs.
Send batch emails to a distribution list from a database or other source. Send HTML emails. Send emails with attachments.
XSLT and XML
Use XSLT to filter and transform XML data, convert XML into SQL statements, convert data into web pages and much more. A powerful XSLT extension library is included to provide a vast array of functions.
Retrieve web pages. Call web forms and web services. "Clean up" html pages into XHTML pages in order to "scrape" them using XSLT.
Run .Net assemblies (components). Call any application with a command line interface.
Microsoft® Message Queing (MSMQ) is a messaging system built into Windows®. It allows messages to be sent guaranteed between computers. Monitor these messages sent from other computers and run jobs on them. Also send MSMQ messages to other machines.
Write a message to the Windows Event Log. Use a preset message or generate it on the fly using information from previous steps, e.g. database queries, file contents, etc.