Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to use job profiler in sql server.

Anonymous User 2124 06 Mar 2016

We want to use job profiler in sql server. How to Do this Please Help Me.

Anonymous User

Other

I am a content writter !

1 Answers

Anonymous User 06 Mar 2016

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.

MindStick Training