What is background job queue in sql server? How to create a background job?

448 views Asked by At

While exploring the SQL server I came up with following system tables:

sys.dm_exec_background_job_queue;
sys.dm_exec_background_job_queue_stats;

Official site tells that

It Returns a row for each query processor job that is scheduled for asynchronous (background) execution.

So how can I create a background (Asynchronous) jobs what will populate these system tables to see queued jobs in these tables or somewhere else?

PS: I am new to SQL Server I don't know if there is something like background job! Correct me if I am wrong.

0

There are 0 answers