EN: Page: 1
CN-import-EN-16692:Inserting Job ID[640419]: Track Welder
CN-import-EN-16690:Inserting Job ID[640420]: Senior Specialist, Data Developer (Contract)
CN-import-EN-16643:Updating Job ID[637418]: Bridges & Structures Carpenter
CN-import-EN-16564:Updating Job ID[632150]: Work Equipment Heavy Duty Mechanic (Mechanic A)
CN-import-EN-15581:Updating Job ID[587235]: Heavy Duty Equipment Mechanic, 310T License
CN-import-EN-14686:Updating Job ID[532955]: Heavy Duty Mechanic Intermodal
CN-import-EN-16598:Updating Job ID[633952]: Rail Track Maintainer
CN-import-EN-16592:Updating Job ID[633957]: Rail Track Maintainer
CN-import-EN-16180:Inserting Job ID[640421]: Intern, Assistant Project Manager
CN-import-EN-16682:Updating Job ID[639378]: Mechanic A
CN-import-EN-16593:Updating Job ID[633956]: Rail Track Maintainer
CN-import-EN-16679:Updating Job ID[639379]: Mechanic Advisor
CN-import-EN-16678:Updating Job ID[639380]: Intern, Sales & Marketing (Regional)
CN-import-EN-16456:Updating Job ID[621445]: Rail Track Maintainer (Prairie Production)
CN-import-EN-16034:Updating Job ID[603455]: Supervisor, Program - Track Maintenance
CN-import-EN-16668:Updating Job ID[638406]: Work Equipment HDM (Mechanic A)
CN-import-EN-16528:Updating Job ID[628859]: Flag Person (Prairies)
CN-import-EN-16660:Updating Job ID[638016]: Track Maintainer/Truck Driver
CN-import-EN-16650:Updating Job ID[638017]: Permanent Machine Operator
CN-import-EN-16600:Updating Job ID[633950]: Track Maintenance Foreman
CN-import-EN-16184:Updating Job ID[637416]: Intern, Data Analyst (Finance)
CN-import-EN-16648:Updating Job ID[637417]: Track Maintenance Foreperson
CN-import-EN-16628:Updating Job ID[637419]: Pilot
CN-import-EN-16589:Updating Job ID[633370]: Intern, Early Careers Analyst
CN-import-EN-16350:Updating Job ID[632988]: Intern, Procurement and Supply Management - Indigenous
EN: Page: 2
CN-import-EN-16349:Updating Job ID[618444]: Intern, Safety - Indigenous
CN-import-EN-16332:Updating Job ID[616179]: Intern, Network Operations - Indigenous
CN-import-EN-16331:Updating Job ID[616180]: Intern, Multimodal Operations - Indigenous
CN-import-EN-16328:Updating Job ID[616183]: Intern, Internal Audit - Indigenous
CN-import-EN-16318:Updating Job ID[616184]: Intern, Financial Planning-Indigenous
CN-import-EN-16316:Updating Job ID[616518]: Intern, Engineering - Operation - Indigenous
CN-import-EN-16315:Updating Job ID[616519]: Intern, Engineering - Design and Construction - Indigenous
CN-import-EN-16314:Updating Job ID[616520]: Intern, Public Affairs - Indigenous
CN-import-EN-16313:Updating Job ID[616521]: Intern, HR - Indigenous
CN-import-EN-16312:Updating Job ID[616522]: Intern, Sales & Marketing - Indigenous
CN-import-EN-16310:Updating Job ID[616523]: Intern, Accounting - Indigenous
CN-import-EN-16256:Updating Job ID[614834]: Intern, Mechanical - Indigenous
CN-import-EN-16222:Updating Job ID[630240]: Intern, Procurement (Operations)
CN-import-EN-16517:Updating Job ID[627090]: Intern, Market Analyst (Industrial Products) - Indigenous
CN-import-EN-16440:Updating Job ID[619666]: Intern, Transformation - Indigenous
CN-import-EN-16353:Updating Job ID[618442]: Intern, Operational Technology - Indigenous
CN-import-EN-16344:Updating Job ID[618447]: Intern, Treasury & Taxation-Indigenous
CN-import-EN-16355:Updating Job ID[616174]: Intern, Supply Chain - Indigenous
CN-import-EN-16359:Updating Job ID[616176]: Intern, IT Operations & Technology Enablement - Indigenous
CN-import-EN-16358:Updating Job ID[616177]: Intern, Solution Delivery - Indigenous
Success:INSERT INTO careers_importer_log (il_company, il_ids) VALUES ('CN','640419,640420,640421') :
Count: 46
Success: UPDATE careers_alink_jobs SET is_active=0, job_status='Inactive'
WHERE job_status<>'Inactive' AND careersid NOT IN (637418,632150,587235,532955,633952,633957,639378,633956,639379,639380,621445,603455,638406,628859,638016,638017,633950,637416,637417,637419,633370,632988,618444,616179,616180,616183,616184,616518,616519,616520,616521,616522,616523,614834,630240,627090,619666,618442,618447,616174,616176,616177,640419,640420,640421)
AND job_slug LIKE 'CN-import-EN-%'
FR: Page: 1
CN-import-FR-16692:Inserting Job ID[640422]: Préposé à l’entretien de la voie ferrée
CN-import-FR-16690:Inserting Job ID[640423]: Spécialist(e) senior, développeur de données (Contrat)
CN-import-FR-16643:Updating Job ID[637431]: Carpenter
CN-import-FR-16564:Updating Job ID[632154]: Mécanicien d'équipement lourd et de matériel remorqué
CN-import-FR-15581:Updating Job ID[587238]: Mécanicien de machinerie lourde, License 310T
CN-import-FR-14686:Updating Job ID[532961]: Mécanicien d'équipement lourd
CN-import-FR-16598:Updating Job ID[633965]: Préposé à l’entretien de la voie ferrée
CN-import-FR-16592:Updating Job ID[633970]: Préposé à l’entretien de la voie ferrée
CN-import-FR-16180:Inserting Job ID[640424]: Stagiaire, Adjoint (e) Chef de Projet
CN-import-FR-16682:Updating Job ID[639381]: Mécanicien A
CN-import-FR-16593:Updating Job ID[633969]: Préposé à l’entretien de la voie ferrée
CN-import-FR-16679:Updating Job ID[639382]: Mécanicien Conseil
CN-import-FR-16678:Updating Job ID[639383]: Stagiaire, Ventes et Marketing (Régionale)
CN-import-FR-16456:Updating Job ID[621449]: Préposé à l’entretien de la voie ferrée
CN-import-FR-16034:Updating Job ID[603461]: Superviseur ou superviseure Programme – Entretien des voies
CN-import-FR-16668:Updating Job ID[638410]: Mécanicien d'équipement lourd et de matériel remorqué
CN-import-FR-16528:Updating Job ID[628870]: Signaleur/Signaleuse
CN-import-FR-16660:Updating Job ID[638019]: Mainteneur de voie/chauffeur de camion
CN-import-FR-16650:Updating Job ID[638020]: Conducteur permanent de machines
CN-import-FR-16600:Updating Job ID[633963]: Track Maintenance Foreman
CN-import-FR-16184:Updating Job ID[637429]: Stagiaire, Analyste de Données (Finance)
CN-import-FR-16648:Updating Job ID[637430]: Contremaître ou contremaîtresse de la voie
CN-import-FR-16628:Updating Job ID[637432]: Pilote
CN-import-FR-16589:Updating Job ID[633374]: Stagiaire, Analyste Programmes de Début de Carrière
CN-import-FR-16350:Updating Job ID[632996]: Stagiaire Gestion des achats et approvisionnements- Autochtones
FR: Page: 2
CN-import-FR-16349:Updating Job ID[618462]: Stagiaire, Sécurité - Autochtones
CN-import-FR-16332:Updating Job ID[616191]: Stagiaire Exploitation du réseau - Autochtones
CN-import-FR-16331:Updating Job ID[616192]: Stagiaire Exploitation multimodale - Autochtones
CN-import-FR-16328:Updating Job ID[616195]: Stagiaire Vérification interne - Autochtones
CN-import-FR-16318:Updating Job ID[616196]: Stagiaire Planification financière-Autochtones
CN-import-FR-16316:Updating Job ID[616526]: Stagiaire, Ingenierie Operation - Autochtones
CN-import-FR-16315:Updating Job ID[616527]: Stagiaire Affaires publiques - Autochtones
CN-import-FR-16314:Updating Job ID[616528]: Stagiaire Affaires publiques - Autochtones
CN-import-FR-16313:Updating Job ID[616529]: Stagiaire, Vente & Marketing - Autochtones - copy
CN-import-FR-16312:Updating Job ID[616530]: Stagiaire, Vente & Marketing - Autochtones
CN-import-FR-16310:Updating Job ID[616531]: Stagiaire, Comptabilité - Autochtones
CN-import-FR-16256:Updating Job ID[614856]: Stagiaire, Mécanique - Autochtones
CN-import-FR-16222:Updating Job ID[630241]: Agent stagiaire ou agente stagiaire Approvisionnement
CN-import-FR-16517:Updating Job ID[627095]: Analyste stagiaire de marché Produits industriels - Autochtones
CN-import-FR-16440:Updating Job ID[619674]: Stagiaire, Transformation - Autochtones
CN-import-FR-16353:Updating Job ID[618460]: Stagiaire, Technologies opérationnelles - Autochtones
CN-import-FR-16344:Updating Job ID[618465]: Stagiaire, Trésorerie et Fiscalité - Autochtones
CN-import-FR-16355:Updating Job ID[616186]: Stagiaire, en chaîne d'approvisionnement - Autochtones
CN-import-FR-16359:Updating Job ID[616188]: Stagiaire, Activation de Sécurité des Technologies Opérationnelles (OT) - Autochthone
CN-import-FR-16358:Updating Job ID[616189]: Stagiaire livraison de solutions - Autochtones
Success:INSERT INTO careers_importer_log (il_company, il_ids) VALUES ('CN','637418,632150,587235,532955,633952,633957,639378,633956,639379,639380,621445,603455,638406,628859,638016,638017,633950,637416,637417,637419,633370,632988,618444,616179,616180,616183,616184,616518,616519,616520,616521,616522,616523,614834,630240,627090,619666,618442,618447,616174,616176,616177,640419,640420,640421640422,640423,640424') :
Count: 91
Success: UPDATE careers_alink_jobs SET is_active=0, job_status='Inactive'
WHERE job_status<>'Inactive' AND careersid NOT IN (637418,632150,587235,532955,633952,633957,639378,633956,639379,639380,621445,603455,638406,628859,638016,638017,633950,637416,637417,637419,633370,632988,618444,616179,616180,616183,616184,616518,616519,616520,616521,616522,616523,614834,630240,627090,619666,618442,618447,616174,616176,616177,637431,632154,587238,532961,633965,633970,639381,633969,639382,639383,621449,603461,638410,628870,638019,638020,633963,637429,637430,637432,633374,632996,618462,616191,616192,616195,616196,616526,616527,616528,616529,616530,616531,614856,630241,627095,619674,618460,618465,616186,616188,616189,637418,632150,587235,532955,633952,633957,639378,633956,639379,639380,621445,603455,638406,628859,638016,638017,633950,637416,637417,637419,633370,632988,618444,616179,616180,616183,616184,616518,616519,616520,616521,616522,616523,614834,630240,627090,619666,618442,618447,616174,616176,616177,640419,640420,640421640422,640423,640424)
AND job_slug LIKE 'CN-import-FR-%'