Post reply

How to Shedule Stored Procedure In Sql Job so that it run daily

  • July 20, 2011 at 6:07 am

    #244678

    Hi,

    I have made one Stored Procedure.

    Now, I want my Sp to execute on daily basis at 8:AM.

    Can anybody tel me how to make SP into JOB.

    Its' quite urgent

    Thanks.

    Deepika

  • July 20, 2011 at 6:09 am

    #1355507

    Open ssms

    Sql agent

    Jobs

    Right click to create a new job. From there on out the GUI is quite clear.

  • July 20, 2011 at 11:13 pm

    #1356148

    use msdb

    go

    exec sp_add_job @job_name = N'MyJob'

    go

    exec sp_add_jobserver @job_name = N'MyJob', @server_name = N'MyServer'

    go

    exec sp_add_jobstep @job_name = N'MyJob', @step_name = N'MyJobStep', @subsystem = N'TSQL', @database_name = N'MyDatabase', @command = 'EXECUTE dbo.spMySP'

    go

    exec sp_add_jobschedule @name = 'MySchedule',

    @job_name = N'MyJob', @freq_type = 4, @freq_interval = 1, @freq_subday_type = 0x1, @active_start_date = '20110721', @active_start_time = '0800000'

    go

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply