Home > DeveloperSection > Forums > How to use job profiler in sql server.
Ankit Singh

Total Post:341

Points:2389
Posted on    March-06-2016 10:11 PM

 Database SQL Server  SQL 
Ratings:


 1 Reply(s)
 279  View(s)
Rate this:
We want to use job profiler in sql server. How to Do this Please Help Me.


aditya kumar Patel

Total Post:244

Points:1736
Posted on    March-06-2016 10:47 PM

Here we are going to create a scheduler  using 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.

 


Don't want to miss updates? Please click the below button!

Follow MindStick