How to run Excel macros and queries in EnterpriseSCHEDULE

SUMMARY

EnterpriseSCHEDULE now offers job prototypes that run an internal or external Excel macro or query and send output to a pdf. This FAQ describes how to set up the job to do this.

MORE INFORMATION

Using these prototypes you can schedule a job to run a macro in Excel and have the output directed to a pdf file report automatically. Using another provided prototype, you can also run a query of a variety of data sources including

• Access database
• Web Services
• SQL Database
• SQL Server Analysis Services
• XML Data
• Microsoft Query

The extract can then be output to a pdf file report by the job for automated query extracts on a regular basis.

For a detailed FAQ on how to install, create and run Excel job in EnterpriseSCHEDULE select one of the following FAQs:

344. How to run Excel macros with parameters in EnterpriseSCHEDULE
343. How to run Excel queries in EnterpriseSCHEDULE
342. How to run Excel macros in EnterpriseSCHEDULE

(ISE logon required).

What would happen if your license expired or a hardware change rendered EnterpriseSCHEDULE unlicensed and it was off hours? What if you had jobs that needed running right away? EnterpriseSCHEDULE licensed users can always access the ISE Registrar site (registrar.i-s-e.com) to obtain a disaster recovery license... a 2 week server license that will get you going until EnterpriseSCHEDULE license support can get you a permanent license. Just go to http://registrar/Customer/DisasterRecovery.aspx and click on Generate Disaster Recovery License. Contact ISE at 310-643-7310 if you have any questions or need your login credentials.

EnterpriseSCHEDULE is the only complete cross platform solution for all the job scheduling and workflow needs of your enterprise. Now your datacenter can free itself of the manual processing of a variety of tasks that dominate your daily routine. Using the software, you can gain control of the operations that are most cumbersome and time consuming to manage, from order and report processing to data warehousing.

EnterpriseSCHEDULE's graphic workflow layouts and job monitoring tools let you plan, control and monitor your job activity from an easy to use Windows based interface. Integrating simple implementation of workflow with the availability of advanced capabilities lets all levels of users take advantage of the powerful features. With sophisticated scheduling tools like advanced job dependencies, job flow based on the value of interactive resource variables, workgroup processing and data replication and event and time based job initiation, EnterpriseSCHEDULE is the best job scheduler available for AIX, Windows, OpenVMS, Solaris, HP-UX, Linux and Tru64 UNIX.