schedule problem

Maciej

Hi
I have problem with scheduling tasks.
I have one SP, where I decide to fire or not another SP and I prepare
parameters for this new SP. The problem is I want to fire this new SP
with delay.
For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
at 1:00 AM.
Is it possible to create this programatically ??

Thx for any help and seggestions.

Maciej

Jul 20 '05 #1

Subscribe Post Reply

1761

Erland Sommarskog

Maciej (ma*******@poczta.onet.pl) writes:

I have problem with scheduling tasks.
I have one SP, where I decide to fire or not another SP and I prepare
parameters for this new SP. The problem is I want to fire this new SP
with delay.
For example SP1 is executing at 4:00 PM and this SP1 makes SP2 to fire
at 1:00 AM.
Is it possible to create this programatically ??

There is a whole load of system procedures for SQL Agent, so I guess
this is possible. sp_add_jobschedule may be a start. Please refer to
Books Online for details. See below for a linke to an updated version.
(Disclaimer: I have never done this sort of thing myself.)

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 20 '05 #2

by: Adisorn Ratanakovit | last post by:

When you set up a full-text catalog in SQL Server and you set up the population schedule, a job gets created and scheduled under SQL Server Agent. The problem I encountered recently is when I...

Microsoft SQL Server

Adjusting schedule in Access query - operations question

by: argniw | last post by:

I have a schedule of annual events that need to occur in different locations throughout the year. Each event has a due date associated with it. I also have an optimal schedule that consolidates...

Microsoft Access / VBA

Janus schedule control print question.

by: greg7224 | last post by:

I am currently working on a C# project that uses the Janus schedule controls, and am having trouble getting it to print correctly in Day view. The problem is that it will not print out the owners...

C# / C Sharp

How do I schedule events for execution ?

by: pamelafluente | last post by:

Hi guys! I want to do a large number of scheduled task (say 80). Each task can be run at a certain time every given weekday. For instance at 10am and 5pm on each monday, etc. I would like to...

Visual Basic .NET

Employee Schedule

by: tstutting | last post by:

Hello, This is my first post and I'd really appreciate any help I can get. Sorry this is so long but it's complicated. I'm a USAF Officer and I'm attempting to make a shared MS Access DB that...

Microsoft Access / VBA

How to schedule ClickOnce application

by: hgirma | last post by:

Hello Gurus, Is it possible to schedule a task to run an application deployed using ClickOnce? The executable changes location with each update.. and if i were to run the executable directly,...

C# / C Sharp

Schedule more access applications

by: amduke | last post by:

Hello, I'm using the Microsoft Scheduler to schedule 6 access application. Each application is scheduled on a different time starting at 03:00 am and the last one is scheduled 07:30 am. The...

Microsoft Access / VBA

looping to insert event types into schedule

by: assgar | last post by:

Hi I am having problem with my loping. I don't know if I have chosen the correct approach. GOAL: I need to insert into a table event types for a specific date range. The calendar the event...

PHP

How to schedule MySQL backups?

by: samikhan83 | last post by:

i love mysql..... i have my applications running on mysql database... everything works fine..... if i execute the back up manually i am getting the full back up...... i am having the problem...

MySQL Database

How-to: A formatted schedule table

by: Czechnology | last post by:

Hi all! I'm programming a small internet radio player in C# and as a part of it, I wanted to include the station's time schedule. Now the problem is, I have no idea what would be the best...

C# / C Sharp

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

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...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

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++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Similar topics