#pgagent

--- a/connection.cpp +++ b/connection.cpp @@ -313,15 +313,7 @@ int DBconn::ExecuteVoid(const wxString &query)

wxString DBconn::GetLastError() { -       // Return the last error message, minus any trailing line ends -       if (lastError.substr(lastError.length() - 2, 2) == wxT("\r\n")) // DOS -               return lastError.substr(0, lastError.length() - 2); -       else if (lastError.substr(lastError.length() - 1, 1) == wxT("\n")) // Unix -               return lastError.substr(0, lastError.length() - 1); -       else if (lastError.substr(lastError.length() - 1, 1) == wxT("\r")) // Mac -               return lastError.substr(0, lastError.length() - 1); -       else -               return lastError; +       return lastError.Trim(true); }

With pgagent you can easily switch from cron for scheduling (database) jobs. One of the problems you might be facing is to mail the output of one or more selects. The lack of a "mail me the output" switch can be easily overcome by using the underlying OS tools like mutt. Figuring out how to do that might be a bit cumbersome. So I figured I'd make a gist for it. This ought to work with only configuration adjustments (setting the database and mail address).