Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Aginity Workbench Users?

Author  Topic 

SQLnoobs
Starting Member

1 Post

Posted - 2015-04-16 : 19:15:17
I recently switched companies and have gone from using SQL Server to Aginity. My new company won't let us into the DB directly, so we have to access it through Netezza and a jump box using the Aginity utility, and query out of a Data Warehouse.

My question concerns the ability to create in Aginity what would be called a Job in SQL Server. I have to login to Aginity daily to manually execute a few queries. I am looking for a way to automate this process, so the queries run once a day automatically and writes the results to a CSV file. I've searched online and looked through the Aginity manual, but see no way of automating queries I have already written.

Any ideas?

Thanks in advance everyone.
SQLnoobs
   

- Advertisement -