Please see if below (done in 2008R2) converts program_name column into matching job_id. If it works you can further converted it into function.

DECLARE @program_name nvarchar(200)

...

I am not a fan of having multiple Oracle databases on the same server and will try to avoid it. As Paul B stated, it requires additional resources for each...

There are currently 6 different servers, 6 instances, and 6 databases. Each instance/database are on its own server. The task is to consolidate the 6 databases into 1 to reduce...

I know this topic is fairly old, but came upon it as we are having similar issue. Our issue is that we have 6 different plants running 6 different databases...