MSSQL — получить список JOB с помощью SQL запроса

Пример вывода списка заданий JOB с помощью запроса из системных таблиц. Запрос выводит только те задания, которые созданы в Database Maintenance. Если вам нужны все, то уберите «AND [sCAT].[name] = N’Database Maintenance'» из запроса:

• [JobName]: название задания агента SQL Server.
• [JobOwner]: владелец задания.
• [JobCategory]: категория, к которой относится задание, например моментальный снимок репликации, обслуживание базы данных, отправка журналов и т.д.
• [JobDescription]: описание задания.
• [JobStartStepNo]: номер шага, из которого задано задание для запуска.
• [JobStartStepName]: имя шага, с которого задание начинается.
• [JobCreatedOn]: дата и время создания задания.
• [JobLastModifiedOn]: дата и время последнего изменения задания.
• [IsEnabled]: индикатор, показывающий, включено ли задание.
• [IsScheduled]: индикатор, указывающий, запланировано ли задание или нет.
• [ScheduleType]: тип расписания.
• [Occurrence]: график задания, такого как Ежедневный, Еженедельный, Ежемесячный и т.д.
• [Recurrence]: повторение графика.
• [Frequency]: как часто задание должно выполняться.
• [JobScheduleName]: имя расписания, связанного с заданием.
• [LastRun]: дата и время выполнения задания в последний раз (соответствует самому последнему запуску).
• [LastRunStatus]: состояние или результат последнего запуска задания.
• [LastRunDuration]: Продолжительность последнего выполнения задания.
• [MaxDuration]: максимальная продолжительность задания.
• [NextRun]: дата и время следующего запуска.
• [JobDeletionCriterion]: критерий для удаления задания.
• [OriginatingServerName]: сервер, с которого выполнялось задание.
• [Subsystem]: тип операции, например, интеграция с SQL Server Пакет услуг, Transact-SQL Script (T-SQL), ActiveX Script и т.д.
• [Command]: фактическая команда, которая будет выполнена.
• [Message]: информация о успехе/неудаче работы и т.д.

Job Objects

A job object allows groups of processes to be managed as a unit. Job objects are namable, securable, sharable objects that control attributes of the processes associated with them. Operations performed on a job object affect all processes associated with the job object. Examples include enforcing limits such as working set size and process priority or terminating all processes associated with a job.

Creating Jobs

To create a job object, use the CreateJobObject function. When the job is created, no processes are associated with the job.

To associate a process with a job, use the AssignProcessToJobObject function. After a process is associated with a job, the association cannot be broken. A process can be associated with more than one job in a hierarchy of nested jobs. For more information, see Nested Jobs.

WindowsВ 7, Windows ServerВ 2008В R2, WindowsВ XP with SP3, Windows ServerВ 2008, WindowsВ Vista and Windows ServerВ 2003: A process can be associated with only one job. Jobs cannot be nested. The ability to nest jobs was added in WindowsВ 8 and Windows ServerВ 2012.

You can specify a security descriptor for a job object when you call the CreateJobObject function. For more information, see Job Object Security and Access Rights.

Managing Processes in Jobs

After a process is associated with a job, by default any child processes it creates using CreateProcess are also associated with the job. (Child processes created using Win32_Process.Create are not associated with the job.) This default behavior can be changed by setting the extended limit JOB_OBJECT_LIMIT_BREAKAWAY_OK or JOB_OBJECT_LIMIT_SILENT_BREAKAWAY_OK for the job.

• If the job has the extended limit JOB_OBJECT_LIMIT_BREAKAWAY_OK and the parent process was created with the CREATE_BREAKAWAY_FROM_JOB flag, then child processes of the parent process are not associated with the job.
• If the job has the extended limit JOB_OBJECT_LIMIT_SILENT_BREAKAWAY_OK, then child processes of any parent process associated with the job are not associated with the job. It is not necessary for parent processes to be created with the CREATE_BREAKAWAY_FROM_JOB flag.

If the job is nested, the breakaway settings of parent jobs in the hierarchy affect whether child processes are associated with another job in the hierarchy. For more information, see Nested Jobs.

To determine if a process is running in a job, use the IsProcessInJob function.

To terminate all processes currently associated with a job object, use the TerminateJobObject function.

Job Limits and Notifications

A job can enforce limits such as working set size, process priority, and end-of-job time limit on each process that is associated with the job. If a process associated with a job attempts to increase its working set size or process priority from the limit established by the job, the function calls succeed but are silently ignored. A job can also set limits that trigger a notification when they are exceeded but allow the job to continue to run.

To set limits for a job, use the SetInformationJobObject function. For a list of possible limits that can be set for a job, see the following topics:

Security limits must be set individually for each process associated with a job object. For more information, see Process Security and Access Rights.

WindowsВ XP with SP3 and Windows ServerВ 2003: The SetInformationJobObject function can be used to set security limitations for all processes associated with a job object. Starting with WindowsВ Vista, security limits must be set individually for each process associated with a job object.

If the job is nested, parent jobs in the hierarchy influence the limit that is enforced for the job. For more information, see Nested Jobs.

If the job has an associated I/O completion port, it can receive notifications when certain job limits are exceeded. The system sends messages to the completion port when a limit is exceeded or certain other events occur. To associate a completion port with a job, use the SetInformationJobObject function with the job object information class JobObjectAssociateCompletionPortInformation and a pointer to a JOBOBJECT_ASSOCIATE_COMPLETION_PORT structure. It is best to do this when the job is inactive, to reduce the chance of missing notifications for processes whose states change during the association of the completion port.

All messages are sent directly from the job as if the job had called the PostQueuedCompletionStatus function. A thread must monitor the completion port using the GetQueuedCompletionStatus function to pick up the messages. Note that, with the exception of limits set with the JobObjectNotificationLimitInformation information class, delivery of messages to the completion port is not guaranteed; failure of a message to arrive does not necessarily mean that the event did not occur. Notifications for limits set with JobObjectNotificationLimitInformation are guaranteed to arrive at the completion port. For a list of possible messages, see JOBOBJECT_ASSOCIATE_COMPLETION_PORT.

Resource Accounting for Jobs

The job object records basic accounting information for all its associated processes, including those that have terminated. To retrieve this accounting information, use the QueryInformationJobObject function. For a list of the accounting information that is maintained for a job, see the following topics:

If the job object is nested, accounting information for each child job is aggregated in its parent job. For more information, see Nested Jobs.

Managing Job Objects

The state of a job object is set to signaled when all of its processes are terminated because the specified end-of-job time limit has been exceeded. Use WaitForSingleObject or WaitForSingleObjectEx to monitor the job object for this event.

To obtain a handle for an existing job object, use the OpenJobObject function and specify the name given to the object when it was created. Only named job objects can be opened.

To close a job object handle, use the CloseHandle function. The job is destroyed when its last handle has been closed and all associated processes have been terminated. However, if the job has the JOB_OBJECT_LIMIT_KILL_ON_JOB_CLOSE flag specified, closing the last job object handle terminates all associated processes and then destroys the job object itself. If a nested job has the JOB_OBJECT_LIMIT_KILL_ON_JOB_CLOSE flag specified, closing the last job object handle terminates all processes associated with the job and its child jobs in the hierarchy.

Managing a Process Tree that Uses Job Objects

Starting with WindowsВ 8 and Windows ServerВ 2012, an application can use nested jobs to manage a process tree that uses more than one job object. However, an application that must run on WindowsВ 7, Windows ServerВ 2008В R2, or earlier versions of Windows that do not support nested jobs must manage the process tree in other ways.

If a tool must manage a process tree that uses job objects and it is not possible to use nested jobs, both the tool and the members of the process tree must cooperate. Use one of the following options:

Use the JOB_OBJECT_LIMIT_SILENT_BREAKAWAY_OK limit. If the tool uses this limit, it cannot monitor an entire process tree. The tool can monitor only the processes it adds to the job. If these processes create child processes, they are not associated with the job. In this option, child processes can be associated with other job objects.

Use the JOB_OBJECT_LIMIT_BREAKAWAY_OK limit. If the tool uses this limit, it can monitor the entire process tree, except for those processes that any member of the tree explicitly breaks away from the tree. A member of the tree can create a child process in a new job object by calling the CreateProcess function with the CREATE_BREAKAWAY_FROM_JOB flag, then calling the AssignProcessToJobObject function. Otherwise, the member must handle cases in which AssignProcessToJobObject fails.

The CREATE_BREAKAWAY_FROM_JOB flag has no effect if the tree is not being monitored by the tool. Therefore, this is the preferred option, but it requires advance knowledge of the processes being monitored.

Prevent breakaways of any kind by setting neither the JOB_OBJECT_LIMIT_BREAKAWAY_OK nor the JOB_OBJECT_LIMIT_SILENT_BREAKAWAY_OK limit. In this option, the tool can monitor the entire process tree. However, if a child process attempts to associate itself or another child process with a job by calling AssignProcessToJobObject, the call will fail. If the process was designed to be associated with a specific job, this failure may prevent the process from working properly.

List and Execute Oozie jobs from the command line

I just deployed a oozie job. Now when I go to the oozie web ui . i just cannot see the job I deployed.

Is there a command line tool which will allow me to do two things

List all the jobs which are deployed (not running, active, killed). but deployed. like an inventory of all jobs.

execute a job from the command line. (on demand, not based on schedule).

1 Answer 1

As already mentioned in one of the comments that oozie in itself is a command line tool.

Therefore, to answer both of your questions:

1. List all jobs
   • For listing all workflow jobs use the following command
     1. oozie jobs
     2. oozie jobs -jobtype wf
   • For listing all coordinator jobs use the following command from the console
     1. oozie jobs -jobtype coordinator
2. Execute a job from command line
   • oozie job —oozie http://oozie-url:11000/oozie -config job.properties -run

Mind you that if you want to keep on starting on demand job either you have to run the above command manually (also only for workflow jobs, not for coordinator jobs as coordinator jobs would be scheduled according to the schedule you define) or put in a shell script so that it is triggered under certain situations

For more info check this link — Oozie_Command_Line_Usage

List of Occupations: Useful List of 70 Professions in English

List of occupations! Below is a useful list of professions in English. This list includes many names of jobs and occupations around the world with examples and ESL infographics.

Table of Contents

List of Occupations

List of Professions

Learn the list of occupations in English.

• Accountant
• Actor/ Actress
• Architect
• Artist
• Astronaut
• Baker
• Ballet Dancer
• Bartender
• Bellboy
• Biologist
• Boxer
• Bus Driver
• Businessman
• Butcher
• Cameraman
• Caretaker
• Carpenter
• Cashier
• Chef
• Computer Programmer
• Customs Officer
• Delivery Man
• Dentist
• Diver
• Doctor
• Electrician
• Engineer
• Entrepreneur
• Factory Worker
• Farmer
• Fireman
• Fisherman
• Flight Attendant
• Florist
• Gardener
• Gas Station Attendant
• Guitarist
• Hairdresser
• Judge
• Lawyer
• Librarian
• Lifeguard
• Miner
• Model
• Musician
• Nurse
• Office Worker
• Optician
• Paramedic
• Pharmacist
• Photographer
• Pilot
• Plumber
• Police Officer
• Politician
• Priest
• Real Estate Agent
• Receptionist
• Repairman
• Scientist
• Singer
• Speaker
• Student
• Surgeon
• Tailor
• Taxi Driver
• Teacher
• Veterinarian
• Violinist
• Waiter

Occupations with Examples

Accountant

• He is going to be an accountant.

Actor/ Actress

• He won the best actor award.

Architect

• Nina is studying to be an architect.

Artist

• The young artist showed me his recent canvases.

Astronaut

• An astronaut will attempt to leave the stationary spaceship and then return to it.

Baker

• The baker bakes his bread in the bakery.

Ballet Dancer

• I wanted to be a ballet dancer when I was a child.

Bartender

• The bartender handed me a mug of lukewarm beer.

Bellboy

• Here are your keys. The bellboy will take your luggage upstairs.

Biologist

• The biologist stained the specimen before looking at it through the microscope.

Boxer

• The boxer had pummelled his opponent into submission by the end of the fourth round.

Bus Driver

• The bus driver washed the windows as a classical music tape played from his dashboard.

Businessman

• The money was donated by a local businessman who wishes to remain anonymous.

Butcher

• The butcher weighed the meat on the scales.

Cameraman

• The cameraman panned down the camera.

Caretaker

• The caretaker ran out and saw off the boys who had been damaging the fence.

Carpenter

• She was in the second year of her apprenticeship as a carpenter.

Cashier

• She is a cashier in a bank.

Chef

• John worked as a chef in the merchant navy.

Computer Programmer

• He’s left his job as a computer programmer and is working as a consultant for a German firm.

Customs Officer

• The customs officer asked him to empty out the contents of his bag.

Delivery Man

• I did not want to appear like a delivery man.

Dentist

• Visit your dentist twice a year for a check-up.

Diver

• We squatted beside the pool and watched the diver sink slowly down.

Doctor

• My doctor referred me to a hospital specialist.

Electrician

• The electrician ran a wire from the kitchen to the bedroom.

Engineer

• The company reinstated him as chief engineer.

Entrepreneur

• An entrepreneur is more than just a risk-taker. He is a visionary.

Factory Worker

• How many factory workers are in danger of losing their jobs?

Farmer

• The farmer grows potatoes in this field.

Fireman

• The fireman managed to keep the fire under.

Fisherman

• The fisherman plopped the bait into the river.

Flight Attendant

• On the plane, the flight attendant brings you a towelette after your meal.

Florist

• The florist made up an attractive bouquet.

Guitarist

• We advertised for a second guitarist.

Hairdresser

• She set herself up as a hairdresser.

Judge

• He is a clerk for a judge.

Lawyer

• He deposited the papers with his lawyer.

Librarian

• The librarian returned with the book I wanted.

Lifeguard

• I applied for a job as a lifeguard at the community pool.

Musician

• He had been a talented musician in his youth.

Nurse

• A nurse took her arm and led her to a chair.

Office Worker

• I am a regular office worker.

Pharmacist

• The pharmacist will make up your prescription.

Photographer

• I think she’ll be successful as a photographer.

Pilot

• The trainee pilot flew his first solo today.

Receptionist

• The girl is a receptionist at the Beijing Hotel.

Repairman

• The repairman disconnected the TV set before fixing it.

Scientist

• The scientist deserves recognition for his talent.

Student

• He is a student of international politics.

Surgeon

• The surgeon is performing an eye operation.

Tailor

• The tailor has cut my coat very well.

Veterinarian

• He is a veterinarian, he is very kind to animals.

Names of Occupations | Infographic

List of Occupations You Should Know