How to use job profiler in sql server.

Question

Anonymous User · Answer

Here we are going to create a schedulerand  using sql server agentand  job.and 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,
)and and and Go to SQL Server Agent And Create New Job. and and Next Create your Job Name and after complete all process your job scheduler has done.and

forum

How to use job profiler in sql server.

Anonymous User

Can you answer this question?

1 Answers

Liked By