2014-09-02 02:59 PM
I've been given the task of creating a dashboard that includes the success rate of jobs submitted to WFA and a breakout of failures by job type. It appears there isn't a pre-made command to achieve this and the wfa user doesn't have enough access to the WFA database to pull out this information.
Can I get the root password to the WFA database to pull this out of the right tables? Or is there another method to get this information?
I saw somebody post that they backed up the database and then restored to a SQL database they had root privileges for, but that doesn't really sound like a repeatable process on a weekly basis.
2014-09-02 10:31 PM
Unfortunately, there isn't a way. This is being worked for an upcoming release. Untill then pls reach out to your account team to get a workaround.
As we may not able to share the root password for the WFA DB, though its unique for each instance of WFA server.