Instalar MySQL en Linux Centos

1. sudo yum update
2. yum install wget
3. wget http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm
4. sudo rpm -ivh mysql-community-release-el7-5.noarch.rpm
5. yum update
6. sudo yum install mysql-server
7. sudo systemctl start mysqld
8. mysql -u root -p
9. update user SET PASSWORD=PASSWORD("password") WHERE USER='root';
10. sudo systemctl stop mysqld
11. sudo systemctl start mysqld

Borrado de Logs

JOB control-m para;

1. Detectar y borrar todos los logs iguales o anteriores a X días de antigüedad

SO: windows server 2012 o superior

Tipo de job: OS
Correr como command en 1 linea:

forfiles /p "C:\IIS\LOG" /s /m *.log /D -X /C "cmd /c del @path"

nota: X reemplazar el numero de días mínimo a preservar 
ej: D-7 preserva los últimos 7 días de logs

Fin

www.axity.com

Inicio y Reinicio del agente del MS SQL Server

JOB control-m para;

1. Detectar el agente de MS SQL Server si esta abajo y subir el servicio.
2. Reiniciar el agente de MS SQL Server si esta arriba

Tipo de job: OS
Correr como command en 1 linea:

powershell.exe "if ((Get-Service -name SQLSERVERAGENT).Status -eq 'Stopped'){Start-Service SQLSERVERAGENT} if ((Get-Service -name SQLSERVERAGENT).Status -eq 'Running'){Restart-Service SQLSERVERAGENT}"

NOTA: Reemplazar SQLSERVERAGENT por el nombre del servicio de agente correcto
Fin

Job adicionales;
1. Listar servicios que contengan SQL y AGENT; powershell.exe "Get-Service | where-object {$_.name -like '*SQL*AGENT*'}"
2. Devolver el estado de un servicio; powershell.exe "Get-Service -name <NOMBRE_SERVICIO>"


www.axity.com

Laboratorio Online de Control-M

Acá encontraras el laboratorio Online de Control-M

http://bit.ly/2sh7rLc

www.axity.com

Lista de variables reservadas

Name	Format	Description
%%$DATE	yyyymmdd	Current system date (4-digit year).
%%$NEXT	yyyymmdd	Next scheduling date for the job (4-digit year).
%%$ODATE	yyyymmdd	Original scheduling date of the job (4-digit year).
%%$OYEAR	yyyy	Original scheduling year of the job (4-digit year).
%%$PREV	yyyymmdd	Previous scheduling date for the job (4-digit year).
%%$RDATE	yyyymmdd	Installation current working date (4-digit year).
%%$RYEAR	yyyy	Installation current working year (4-digit year).
%%$YEAR	yyyy	Current system year (4-digit year).
%%APPLGROUP	string	Name of the group to which the job belongs.
%%APPLIC	string	Name of the Application to which the job’s group belongs. For z/OS jobs the %%APPL variable is used to reference the Application name.
%%BLANKn	n spaces	Resolves to n blanks, where n is a number between 1 - 214.
%%CENT	yy	First two digits in the current year (for example, 20 in year 2006).
%%CYCLIC	Y|N	This variable is used in the command line of the ctmorder utility to override the Cyclic parameter in cases where the user wishes to order a single run of a job that is defined as cyclic. Y – job is cyclic N – job should be run only once.
%%DATACENTER	string	Name of the Control-M/Server for the current Control‑M installation. This variable is available on certain Control-M computers as of Control‑M version 2.20. However, prior to CONTROL‑M/EM version 6.1.02, %%DATACENTER returned the host name for the current Control‑M/Server.
%%DATE	yymmdd	Current system date.
%%DAY	dd	Current system day.
%%GROUP_ORDID	nnnnnn	Order ID of the Active Folder to which the job belongs. §     This variable is valid only for jobs in an Active folder and it is evaluated in base 10. §     This variable has been retained for versions of Control-M earlier than version 7.0.00.
%%JOBNAME	string	Name of the submitted job. This variable can be used to override the value specified for the JOBNAME parameter (for example, in the ctmorder utility). On a Microsoft Windows computer, JOBNAME must comply with Microsoft naming conventions (for example, it cannot contain / and \ characters).
%%JULDAY	nnn	Current system day of the year (Julian format).
%%MEMLIB	string	Mem Lib (name of the library or directory in which job script is stored) of the job.
%%MONTH	mm	Current system month.
%%NEXT	yymmdd	Next scheduling date for the job.
%%ODATE	yymmdd	Original scheduling date of the job.
%%ODAY	dd	Original scheduling day of the job.
%%OJULDAY	nnn	Original scheduling day of the year (Julian format). For example, 36 for February 5th.
%%OMONTH	mm	Original scheduling month of the job.
%%ORDERID	nnnnnn	Unique job order ID under Control‑M.
%%OWDAY	d	Original scheduling day of the week of the job (1= Sun., 2= Mon., and 0=Sat.).
%%OWNER	string	Owner (user ID) associated with the job.
%%OYEAR	yy	Original scheduling year of the job.
%%POSTCMD	command	Specifies a command to run immediately after running the job defined by MEMNAME. The return code is ignored. Not relevant for z/OS jobs. Relevant only for Control‑M/Server version 6.0.01 or later, or (without OUTPUT) for any job submitted by Control-M/Agent for Microsoft Windows 2000 version 6.0.01 or later. This variable is not used with SMART Folder.
%%PRECMD	command	Specifies a command to run immediately before running the job defined by MEMNAME. The return code is ignored. Not relevant for z/OS jobs. Relevant only for Control‑M/Server version 6.0.01 or later, or (without OUTPUT) for any job submitted by Control-M/Agent for Microsoft Windows 2000 version 6.0.01 or later. This variable is not used with SMART Folder.
%%PREV	yymmdd	Previous scheduling date for the job.
%%RDATE	yymmdd	Installation current working date.
%%RDAY	dd	Installation current working day.
%%RJULDAY	nnn	Installation current working day of the year (Julian format). For example, 36 for February 5th.
%%RMONTH	mm	Installation current working month.
%%RUNCOUNT	nnnn	Number of times the job order has been submitted for execution (that is, the first time the job is being submitted, this variable returns a value of 1).
%%RWDAY	n	Installation current working day of the week (1=Sun., 2=Mon., and 0=Sat.).
%%RYEAR	yy	Installation current working year.
%%SCHEDTAB	string	Name of the job’s folder. This variable is available on certain Control‑M computers as of Control‑M version 2.2x.
%%FOLDER_ID	nnnnnn	Order ID of the folderto which the job belongs. This variable is valid only for jobs in an active folder and it is evaluated in base 10.
%%TIME	hhmmss	Time of day.
%%WDAY	n	Current system day of the week (1=Sun., 2=Mon., and 0=Sat.).
%%YEAR	yy	Current system year.

www.axity.com