How to use job profiler in sql server.

Total Post:341

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

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

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.