Post reply

How do I make the Database to perform fixed things daily ?

  • December 1, 2005 at 1:05 pm

    #166178

    Hi,

    Actually I want my database to run certain checks daily in the morning. What feature in SQL Server 2000 will enable me to do that. Are scripts something related to that?

    Please give me a pointer from where i can go ahead.

    Thanks,

    Snigdha

  • December 1, 2005 at 1:06 pm

    #607175

    U can create Maintenance Plans or create jobs to run pre-written TSQL scripts to do that. Search in BOL for Maintenance Plans

  • December 1, 2005 at 1:29 pm

    #607182

    Thanks,

    I will look into that and come back if problem persists.

    Snigdha

  • December 1, 2005 at 1:51 pm

    #607191

    Here's the simplest way to get started and learn...

    In Enterprise Manager, expand until you see Management. Expand that. Click on Jobs.

    Right click on Jobs and select New Job. On the Steps tab, you will create one step for each part of your job. This is where you will write the commands that you want to run. On the Schedule tab is where you will set when the job will run. Fill out all that and you now have a job. Let it run and ensure it works.

    Once you have a working job, right click on the job and select Script Job. That will provide you with the code that creates the job. Now you can write your own without using Enterprise Manager.

    -SQLBill

  • December 1, 2005 at 2:01 pm

    #607194

    Wowww...

    this was really clear..I got the entire thing. I think it was something like this I was looking for.

    I will implement it right now....

    thanks a looot.

    Snigdha

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

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