SQL + everyday - Microsoft SQL Server

pri10der

Can somone explain me how to run some procedure everyday at 22:00 in MSSQL.

This is not an Administrative Task, it's my procedure.

Jul 20 '05 #1

Subscribe Reply

1747

Allan Mitchell

A scheduled Job would do it. You simply schedule your Proc to run.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"pri10der" <pr******@icpnet.pl> wrote in message
news:c5**********@topaz.icpnet.pl...

Can somone explain me how to run some procedure everyday at 22:00 in MSSQL.
This is not an Administrative Task, it's my procedure.

Jul 20 '05 #2

pri10der

A scheduled Job would do it. You simply schedule your Proc to run.

I tried but...

Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_add_jobschedule'.

Is there any other posibility?

Jul 20 '05 #3

pri10der

Ok, now I understand why that was so easy for everyone,but not for me...
Thanks for help :)

Jul 20 '05 #4

Similar topics

Restarting Tomcat Server Everyday

by: Shireesha | last post by:

Hi all, I am new to this group and wish clear some doubts regarding tomcat server and database connection pooling (Java language). Our group has developed a application using Tomcat 4.x. We need...

Java

SQL + everyday

by: pri10der | last post by:

Can somone explain me how to run some procedure everyday at 22:00 in MSSQL. This is not an Administrative Task, it's my procedure.

Microsoft SQL Server

A .Net trick everyday!

by: Nuri Yilmaz | last post by:

Dear Member, Today, the HotDotNet members received both C# and VB .NET code with subject "hot.Net- N.145: Using ref (C#) and ByRef (VB) parameters". If you didn't receive it, this means you...

.NET Framework

everyday a new file?

by: Dirk Reske | last post by:

Hello, I write an app that, logs events. how can I make, that everyday a new file whould be createt, with the date as name? thx -- ----------------------------------------------------

C# / C Sharp

A .Net Trick Everyday! (subject of today: SHA1 - Secure Hash Algorithm Class)

by: Nuri YILMAZ | last post by:

Dear Member, Today, the hot.Net members received both C# and VB.NET code with subject "158# SHA1 (Secure Hash Algorithm) class for the passwords and the others". If you didn't receive it, this...

.NET Framework

Earning of Rs.500-Rs.1000 everyday is easy here

by: vasulu | last post by:

Hi, Earning more than Rs.500 per day is easy here. Visit the site. http://www.l-red.com/index.asp?REF=spvarapu

ASP.NET

This is a great NG, I learn a lot reading it everyday <EOM>

by: raylopez99 | last post by:

C / C++

Running php file everyday on scheduled time

by: sachu | last post by:

Hi, Is there is way to run a php file perodically everyday on scheduled time in such a way that there is no human interaction and it performence the written task.

PHP

Code to Import sheet everyday with that day's date as part of name

by: Riun | last post by:

Hi I need to import excel sheet to access - the sheets are stored everyday with the same name, but with the day's date at the end of the name to distinguish them. What code can one use to import...

Microsoft Access / VBA

WANT A MORE PERSONS TO VISIT YOUR SITE EVERYDAY?

by: james | last post by:

Want more persons to visit your site everyday? Add traffic to your sites. Add the CTR ratio and eCPM by posting on various classifieds, just spend five minutes to increase your earning, for details...

C# / C Sharp

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET