![]() Its schedules and steps will be displayed when you extend the job. Once a new job is created, it will be displayed under pgAgent jobs in the browser tree. If you want to schedule a job dynamically you will have to execute the procedure code displayed here. In the Schedules tab we add the start date time and the end date time for the job to start and end. I will save the changes after adding the code. ![]() The code will be:ĬOPY (select * from acc_view) TO E'C:\\test-data\\try.csv' Since I want to export the data from a view, I will call the view and ask it to export the file. Next comes the code section in Steps tab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |