Hello all. I'm having some issues regarding the ETL_INFA cm version 7.0.0. Sometimes i run a workflow that runs Ok in PowerCenter, but it returns the following error in sysout: *** WORKFLOW LOG *** Job failure message: Exception occurred: org.xml.sax.SAXParseException: XML document structures must s...

Hello. Is there a way to pass Auto Edit variables to a .par parameter file using Informatica CM? I have some PowerCenter workflows that use a parameter file that needs to replace some parameters depending on the execution day or time. Can i use Auto Edit to replace these variables in a .par paramete...

th_alejandro, thank you so much. I'll give this script a try. At least for agente that hosts most of the critical jobs. Do you know if there is a way to do the same, but running only in one server, like CTM Server? I was thinking about running some sort of DB Query and make this time calculations fr...

Hi. I have a need that isn't covered natively by Control-m. Need to set an alert to all Jobs that detect if a job is running for more than 24 hours. I thought of using "exectime", but the longer value is 999. Is there a way to do this? If a job is running for more than 24 hours, shout an alert to EC...

fafa1975 wrote:Hi,
I experienced something similar, but there was jobs with old agents on node id.
Try to export all scheduling tables in an xml file and find the agent name. Check even if job is not scheduled.

Fabrizio

Tried this. No entries found in xml file. That's the weirdest thing.

Hi. I'm experiencing a strange issues with my control-m environment. I've deleted 3 hosts from CCM, and after a few hours, the hosts appears again, even with no jobs configured to run on those hosts. Every time I disable and delete them, they reappears. Tried to removing the /incontrol filesystem an...

fyot wrote:Hi

Yes it's possible using SUBSTR function in AUTOEDIT.

example
%%yy=%%SUBSTR %%b 1 2

Thanks, but that one doesn't work for me. If i do this with %%MONTH, it will give me 01, 02, 03 instead of 1, 2, 3 (what i need)...

Hi, everybody! I need an auto-edit variable for MONTH (current month) but in format "M" instead of "MM". Is there a way to do that? I mean, 1 for January (instead of 01), 2 for February, and so on. Of course 10, 11 and 12 will remains the same. In other words, is there a easy way to strip the 0 from...

Yeah! Worked like a charm!

Thanks a lot, man...

Hello folks, how are you doing? I'll try to explain my problem. The NDP is 11 am. I have a cyclic job that must execute from 6am to 11pm, hourly, only on the second and the third workdays. So i've created 2 jobs. One is scheduled on the workdays, and runs from 11am to 11pm. That's ok. The other must...

Hi everyone. I have an urgent issue. My "New day" is set to run at 11am (now it's 7:20 am here), so i need a helping hand. On weekends we have here specific production jobs that runs only on saturday, leaving the sunday for maintenance routines and small runs only. But today i received a demand to r...

Am a newbie, but just posting a solution for the above question that comes to mind. People please correct me if I am wrong. WEEKDAYS = 1,2,3,4,5,6 (i.e. Monday to Saturday) OR DAYS = D8, D9, D10.... till end of month i.e. it will pick up all the days starting from the 8th Day (the first Sunday will...

Hi.

Need to make a job that runs every day of the month EXCEPT in the first sunday.

I know that is easy to do the other way (ex. ONLY at the first sunday of a month), but how can i do what i need without using the calendar?

Thanks in advance.