Post reply

regarding scheduling jobs in sqlserver

  • May 22, 2008 at 11:49 pm

    #380665

    Hi,

    Can you provide complete material regarding jobs in sqlserver.

    As I am a begginer I got general awareness regarding this topic on surfing in sqlserevercentral and somemore through google.

    I want complete material regarding jobs so that I can start my practise regarding this and will get to you for further queries if any.

    Kindly help me in this regard as this topic is very important for me.

    Thanks,

    sudheer.

  • May 23, 2008 at 1:00 am

    #819504

    Hi

    Are you requiring to perform admin tasks by using the SQL scheduler / jobs

    or

    DO you need to create DTS / SSIS packages that run as jobs on the server - also using the job scheduler?

    Also what version of SQL are you using (e.g. SQL 2000 Enterprise, or SQL 2005 Standard)

    let us know

    Thanks

    Kevin

  • May 23, 2008 at 4:16 am

    #819574

    Hi Kevin,

    thanks for your reply.I just want to know basic information regarding jobs like how we can create jobs(eg:using sp in jobs) and how we can schedule them and how to run them.

    I am using SQL SERVER 2005.

    Kindly help me in this regard.

    Thanks,

    Sudheer.

  • May 23, 2008 at 5:49 am

    #819598

    Hi

    Under SQL Server Agent --> Jobs - you can right-click on Jobs and say New Job

    Step 1: Give the Job a Name

    Step 2: Click on Steps

    Step 3: Click on New

    Step 4: Give this step a name

    Step 5: Select Database (can you master for testing)

    Step 6: In the command type: select 'Step 1 of my Job'

    Step 7: Click OK

    Step 8: Click on Schedules

    Step 9: Click on New

    Step 10: Click on New

    Step 11: Type a name for this schedule

    Step 12: Select Daily and every 5 minutes

    Step 13: Click OK

    Step 14: Click OK again

    you have just created a job with 1 step with a schedule

    To execute a stored procedure in the command as in Step 6 - you will replace the text with something like:

    exec sp_name

    let me know if this helps at all

    Thanks

    Kevin

  • May 26, 2008 at 6:31 pm

    #820306

    thanks Kevin,

    regards,

    sudheer

Viewing 5 posts - 1 through 4 (of 4 total)

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