Script a process
Posted on 2012-08-27
I want to script an issue that we have a manual process for. Im not sure if this is possible given the product.
Background info -
The product we use is Deltek MPM. We have a process that syncs projects in MPM to a SQL database. The task is faulty and you have to constantly keep an eye on it.
Basically what it does is you Log into your SQL server. Run a SQL job that we have set up which takes a minute. Then log into MPM and tell it to sync a specific Project. If you go over to the server that runs the sync (separate from the SQL server) you can see the event log that its syncing. If it fails (known bug with MPM) it shoots a bogus Error in the event log. Then you have to repeat the process and it will sync the next time.
Id like to script this if possible where the script is looking for a failure in the event log (its a specific entry) and if it sees this entry it will run the SQL job and then will select the same project to sync again. I dont if there is a way to script for a project to sync since I dont know how MPM is written.
Any help, suggestions, examples would be great. I am somewhat new to scripting. Thanks!