Skip to content

Twenty-Five years old and a BMC control-m Padawan and a SQL Padawan.

Today is my birthday, which means I turn twenty-five. And also a lot of birthday wishes from friends and family. One of the few young people I know my age that is in the SQL Database realm wished me a happy birthday and called me a “SQL Padawan” . A Padawan is the title given to young Jedis in training to become a Jedi knight.  In Star Wars that train in Yoda’s Jedi Academy. At a certain point the top performers or most gifted Padawans are picked by a Jedi Master to instruct him or her in the ways of the force and help him or her become a Jedi knight. The goal is to pass the training your instructor gives you. Once this is completed the Padawan advances to Jedi Knight.  (http://timradney.com) I realized today that last year I was asked to learn control-m and SQL. Yes I am getting closer to being good at control-m Admin. Once I get my scheduling training I will have completed half of my training but will still be behind with SQL. I keep realizing that I am going to have to learn SQL whether I like it or not. I have the educational tools to be on a medium level with SQL. It is all up to me if I want to be good at SQL or just know enough to talk about it and do basic queries. It’s funny to me that I know more about SQL than the average IT professionals yet barely dabble in it. You would think it would motivate me to keep increasing the amount of knowledge I have about SQL. I guess this blog is a start and realization where I should be and where I will be after more effort is applied. Turning twenty-five has already opened my eyes more. It also made me realize that my mentor or Jedi Master/SQL Expert who has already completed so many things in the SQL world. He is also very respected for his knowledge and work ethic. He has picked me as his Padawan for a reason. And also I realized today the only thing keeping him from being a complete Jedi Master is he hasn’t made his first Padawan a Jedi Knight of SQL skills. I think once I get up to par, it will help my career and make me a Jedi Knight in the SQL world, but it will also make Tim Radney a complete Jedi Master in the SQL community.

Young control-m Administrator knows that the BMC Support team has his back.

It’s been a while since my last blog entry and it is way over due. After numerous issues and situations that were out of my control or above me. This control-m project is finally on course and making headway. My skill set has remarkably improved. I would call myself a subpar administrator of control-m instead of somebody thrown into the fire of workload automation. This being mainly because of my relentless pursuit of knowledge on the product and the good people down in Texas working in the BMC Support area. We get a long great because they are relentless as I am about getting work done in a timely fashion. BMC Support is very professional and will help you and your teammates with anything BMC product related you need. Another thing that makes them standout to me is sometimes when things are downloading they make awesome conversation. You can tell these folks enjoy what they are doing and really want to make sure your BMC product is back up to par. I am such a rookie to workload automation it can be overwhelming at times, especially being a young control-m Administrator with a mile long to do list. It makes me feel more confident knowing BMC Support has my back!

Control-m With Big Al overcomes rookie mistake and explains how to make changes to jobs already uploaded into the Enterprise-Mananger.

I decided to blog about this because I made a simple mistake recently when trying to make a easy change to a job already loaded and scheduled in the Enterprise-Manager. I thought it would be nice to write about the proper procedure. This is another example of meticulous procedure of control-m. Now that I know the right way to do this it’s not so bad. Let me explain to you how to correct a job that’s already loaded and scheduled in the EM so you will know how to do this simple task in the future.

You need to login into your control-m desktop account. Click file, select load jobs from control-m/EM. Select the table that has the job(s) that needs the correction. Click Load, shortly afterwards a Load Table Results Window will appear. It will say Table name and jobs successfully loaded/unsucessfully loaded. This time lets say they are successfully loaded. Now the job will appear on the local workspace. (Make sure to use local workspace)  Double Click on the job step you need to make the correction(s) to. A window will appear with ten tabs to make changes to the job by. In this case I am wanting to change a email address for a job owner. This is done in the STEPS Tab. After the change is made click Save/Close. Now you will be back on your local workspace. Click write jobs to control-m/EM. Here it will sit for others to see and add other changes or sit for review by your superior. If it is fully correct go ahead and upload the job. Select Tools, then click Table Manager. Highlight the table this particular job is under and click Upload @ the top of the menu screen. Since I made changes using this procedure they will be added for the next day at time cutoff that the control-m servers are set by. There is a way to make changes immediately without waiting on the cutoff time and also a way to make temporary changes in the Enterprise-Manager that are in effect until the cutoff time. I am not going to explain those tonight maybe some other blog post. FYI If you don’t know your control-m server cutoff times, ask because they are not all set to midnight.

When I tried to go about this I just loaded jobs from the EM into the Desktop made the changes and Saved and Closed. If you do this your corrections will never be added to your job(s). Make sure you remember to make changes ,then Write the job then Upload the job from the Table Manager back into the Enterprise/Manager.

Hope this helps other control-m users out there that stumble across my blog.

Control-m Newbie “Networking, blogging and asking questions has led me to setup Filewatcher jobs”

Recently I edited my blog titled “Being control-m newbie is tough”. Mainly due to the fact my frustrations with the learning curve sounded as if I disliked the product. Personally I am NOT A Hater of BMC or control-m! I think BMC is a top notch company and their product control-m rocks!! I really do see the benefits and the capabilities of control-m. It’s awesome. I get so excited when I learn something new. I am hungry for knowledge and to be able to implement new things I come across, just excites me! In the future I might come across frustrated on my blogs, this is just a normal part of learning new software on the fly! The good thing is I am learning.

The learning curve is tough for control-m because it has so many particular steps for setting up new jobs. The cool thing is though once you learn these steps it becomes second nature. It will take time but eventually a newbie like myself will get there. Tonight I learned alot from nice control-m expert from the BMC community. I actually found the user in the BMC forums and contacted the user. Very helpful and loves control-m and loves helping young newbies like myself. WIN WIN for me!! (Make sure to get involved in the BMC forums in the control-m group on their website) We talked about setting up file watcher jobs and then how to kick off a SSIS package once the file is located. The user went through a step by step process  in the set up menu. Very blessed to have such a nice person take the time to help me! I also realized the two jobs that I have been struggling with do not need powershell scripts to kick off the next step in the job. These next steps can be set up inside of the control-m desktop application. It was worth networking in the control-m community there are lots of knowledgeable folks out there. Don’t be afraid to reach out that’s what they are there for.

Powershell scripts/SQL scripts or half the battle! Need to know more about control-m STEPS coding!!

Recently I tried to take a job from a database and schedule it using control-m. It was basically a job that counts the number of files in a folder and had parameter in it stating that if there weren’t a certain number of files in the folder to send a email to the job owner notifying him files were missing. Sounds simple right. Of course it isn’t simple I am a newbie to control-m.

Luckily I work with very talented colleagues. They specialize in a number of things in the database world. Immediately we realized that setting up a filewatcher job with control-m will not allow you to count files. It only lets you know when a file or multiple files are created or deleted. Then the filewatcher gives you to the options to kick off another task. We didn’t want that in this particular case. We just wanted to be able to count the files in this folder and fail the job if it doesn’t have the minium number specified.

After getting frustrated my talented boss made a nice SQL script to do a count. That worked but it still wasn’t what we wanted. He then created a nice powershell script. It counted the files but yet it still wasn’t what we wanted. We want to know how to make BMC recognize that the file count is less than what it is suppose to be and then fail and give off a exit code. Is there a way to tell control-m using the steps selection if there aren’t the proper number of files  in the folder to fail “notok” and then send a email. That’s where I am today with the scheduler. Trying to learn more about the steps. So far with the steps selection I know how to code a shout to send email for a job ok or for a job failure not ok. And I do know I am in the company of talented coders that can make whatever script I ask for but I want to find more about control-m and what the steps selection is capable of . How is it involved instead of scripting everything in powershell script or a SQL script. Slow progess is progress with control-m. Signing off

Being a control-m newbie is tough!!

The BMC control-m is used by  a few thousand IT professionals through out the world. There are other batch automation schedulers that software companies sell. However BMC’s product control-m happens to be ranked the number 1 batch automation scheduler across the board, it’s ranking are head and shoulders against the competition! There has been alot of thought and effort into the design and it really shows. This tool is very powerful and can really do alot for you once you learn how to use it. I agree with the number 1 ranking Control-m is a very unique scheduling software! And I am glad that I am learning how to use the best batch automation scheduler in the world. It’s very complex and not easy to learn, however once you get past the learning curve it can do wonders for you and your IT department at your company.  The software was originally designed by the Israeli military back in the 1980’s for their mainframe jobs. Eventually it was sold to private companies and eventually  BMC purchased the software rights for it’s company.