Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Paul Gibson: "The strength of SQL Maestro Group's technical skills and support allow us to recommend PostgreSQL Maestro and PostgreSQL Data Wizard to others. Above that, they provide us with amazing value (great service, fair price) in comparison with every other software development teams that I've researched".
Michael Pavitsky: "SQL Maestro Group provided the kind of services and support for managing PostgreSQL data expected in a true business partnership. Their devotion to customer satisfaction and cost curtailment is a pleasure for PostgreSQL users. I wouldn?t hesitate to recommend PostgreSQL Data Wizard to any of my peers and I know and trust they will surpass all expectations".

More

Add your opinion

PostgreSQL Data Wizard online Help

Prev Table of Contents Next

Task Scheduler

PostgreSQL Data Wizard allows you to schedule data manipulation tasks. To import/export data, generate ASP.NET scripts, or convert PostgreSQL  data and structure in background mode at a preset time, you need to:

 

Create a template with a scenario of the process;
Add a new task to the Task Scheduler.

 

Task Scheduler contains the list of scheduled tasks with the time and the result of the last task execution, and the time of the next one. To open the page, use Task Scheduler button at the Ribbon toolbar or the Show Task Scheduler link at the Home page.

 

       Adding a task

 

To add a task to the scheduler, use the Add Task button at the Ribbon toolbar or open the Task Scheduler page and click Add Task at the Navigation bar or at the area's popup menu. The Add Scheduled Task window will appear. Fill the window fields and click OK.

 

Scheduled tool

Select the wizard for the task execution from the drop-down list.

 

Specify the names of template and log files.

 

Set the time for the task to be executed. To execute the task minutely, hourly, daily, weekly or monthly, use the Each box and its drop-down list. To cease the task executing at a specified date or after a certain number of the process repetitions, use the Until and the For drop-down lists.

 

Select the Task type. Three options are available: Application schedule, System schedule and Both types schedule. An application scheduled task is executed by the PostgreSQL Data Wizard Agent itself i.e. it requires a user logon while system tasks can be executed by the Windows scheduler service even without user logon.

 

 

       Editing an existing task

 

To edit the selected task, use the Edit Task item of the Navigation bar or double click the task. The Edit Scheduled Task window will appear. The window parameters are similar as the parameters of the Add Scheduled Task window.

 

 

       Disabling/Enabling a scheduled task

 

To enable/disable scheduled tasks without deleting them, use corresponding links at the Navigation bar.

 

 

       Executing an existing scheduled task

 

If necessary, you can run the configured task any time, irrespective of the specified time. To execute the selected task, use the Execute task item of the popup menu or the Execute Task link of the Navigation bar



Prev Table of Contents Next