---
title: "How to use job profiler in sql server."  
description: "How to use job profiler in sql server."  
author: "Anonymous User"  
published: 2016-03-06  
updated: 2016-03-06  
canonical: https://www.mindstick.com/forum/34035/how-to-use-job-profiler-in-sql-server  
category: "database"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# How to use job profiler in sql server.

We want to use [job](https://www.mindstick.com/articles/167406/how-to-upgrade-your-freelance-designer-job) [profiler in sql](https://www.mindstick.com/forum/156787/what-is-sql-profiler-in-sql-server) server. How to Do this Please Help Me.

## Replies

### Reply by Anonymous User

Here we are going to create a scheduler using [sql server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) agent job.

create two table schedule and schedule_expiration table.

```
CREATE TABLE [dbo].[scheduler](
	[ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
	[Name] [varchar](100) NULL,
	[hours] [int] NULL,
	[Date] [datetime] NULL,
	[Description] [varchar](500) NULL,
)
```

```

CREATE TABLE [dbo].[scheduler_expiration](
	[ID] [int] primary key IDENTITY(1,1) NOT NULL,
	[Sid] [int] NULL,
	[Name] [varchar](100) NULL,
	[hours] [int] NULL,
	[Date] [datetime] NULL,
	[Description] [varchar](500) NULL,

)   Go to SQL Server Agent And Create New Job.
```

```
  Next Create your Job Name
```

```

```

```

```

```

```

```

```

```
 
```

```

```

after complete all process your job scheduler has done.


---

Original Source: https://www.mindstick.com/forum/34035/how-to-use-job-profiler-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.