AnsweredAssumed Answered

Does anyone run Oracle SQL*Plus jobs in Automic, where the actual sql script in in Automic?

Question asked by Eric_Gauthier_248 on Aug 19, 2014
Latest reply on Jun 15, 2017 by Prashant_Gupta_9370

 

When we converted from AM8, to Automation Engine v9, we were not able to put the contents of the sql script for sql*plus jobs into Automic.  We had to create a job and prompset to run the sql*plus job command line.  The actual sql scripts are stored out on a file share.  We would like to utilize some of the features of Automic, such as variables, and version control, etc. and have the scripts inside of Automic.  Is anyone currently doing this successfully and willing to share how they have it setup?  I am trying to remember the issue we had.  It was either something with the password and encryption, or it was not properly interpreting the sql commands correctly.  It has been a while since we have tried it, and situations have come up where we want to explore this option.  If there is not an option to do so, is there an option out there that someone would be willing to share where they are running command like we are, but passing variables to the sql. 

Outcomes