473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Schedule the Jobs in Sql Server 2005

Hi,

I am new to Sql Server Management Studio. Actually I have one table (tblsugg),
I want to clean this table on every friday.
I want to do in Sql server 2005 as a Jobs, which is present in Sql server agent.

So by using the above table, how i can create the Job and schedule it in sql server 2005.

Thanks in advance.


With Regards,
Danish.
Apr 1 '08 #1
1 1011
ck9663
2,878 Expert 2GB
Try reading this

-- CK
Apr 1 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: mustafa | last post by:
Dear Sir, I want to send the bulk MAil to the user at a schedule task.I am using ASP and Sql server 2000. i want to schedule the Date & time like in SQL Server 2000 there is feature to...
1
by: Bob | last post by:
Hi, I run UDB 7.2 I have an ETL schema. I have a jobs flow to populate the warehouse schema. I run the flow manually ( "Run new step" from "Work in progress" window ) and everything works...
1
by: gjiang_usenet | last post by:
Hi, Recently, I got a new client running DB2 UDB EE V7 on Windows 2000. (I am not a Windows guy and do not like it at all.) I found that this database is backed up (online) daily. However, I...
4
by: Good Man | last post by:
Hi there I have a list of jobs scheduled in a MySQL table, with start dates and end dates, like so: SchedID | JobID | StartDate | EndDate |...
1
by: jobs | last post by:
I have a growning list of stored procedures that accept a single string as a parameter. The list and parameters are maintained in a table with two columns. Some of the Stored procedures take...
4
by: bir | last post by:
I want to schedule the perl script on windows server but without using windows task schedule services. I want to write my own script which scedules the script and runs periodically on same day may be...
3
by: BLUE | last post by:
I've to call 2 web method from time to time so that the web service will do cleanup and sync jobs on a database. These methods can be called once every X days where X >= Y for the sync method...
1
by: traceable1 | last post by:
I created a new database instance, but I forgot to script out the scheduled jobs before I wiped out the original database instance. I have attached the original msdb database as msdb_old onto the...
2
NeoPa
by: NeoPa | last post by:
My server is running Windows 2000 (All latest SPs & updates) and I need to start a job in the early hours with a specific network account and in interactive mode. I have been using the AT command...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.