I am attempting to setup a job to run an updating sql script. Has anyone done this before?

[Legacy User]

Has anyone ever setup a sql script to run in Applications Manager?  

[David DeSalvo]

Yes. We do all the time. First thing you want to do besides having an agent, is to create a login object. After you have created your script and placed it in your library, create the job with the AWSQLP program type. On the Execution Options tab, make your Primary Login ID the login object you created.

[Legacy User]

Thank you for the response.  This gave me a start.  However, I am getting a message when I run the job that the "output file does not exist".  I specified in my library where the file is located and the path seems to be correct.  I used both a local and networked path but it won't budge.  Any additional insight would be helpful.

[David DeSalvo]

Check your file permissions. rwx and owner/group.  

[Legacy User]

Thank you, the information you provided was very helpful.

[Clifford Dawkins]

Greetings,

I used the AWSQLP program type and this SQL format to update a production

table we used in generating an internally developed fee. Pretty straight forward

but let me know if you have any questions.

 

Clifford Dawkins

 

 

[Legacy User]

Thanks Clifford.  I will review this and see if it fits what we are attempting to do.