How to use job profiler in sql server.

Total Post:341

Points:2389
 1015  View(s)
Ratings:
Rate this:
We want to use job profiler in sql server. How to Do this Please Help Me.
  1. Post:281

    Points:2003
    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