How to use job profiler in sql server.

Total Post:341

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

    Points:1987
    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!