HOW TO USE JOB PROFILER IN SQL SERVER.

Ankit Singh

Total Post:341

Points:2389
Posted by  Ankit Singh
 658  View(s)
Ratings:
Rate this:
We want to use job profiler in sql server. How to Do this Please Help Me.
  1. aditya kumar Patel

    Post:254

    Points:1810
    Re: How to use job profiler in sql server.

    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.

     

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!