Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Is it possible to asynchronously run the stored procedure? Find similar branches


Delirium   (2001-11-30 18:56) [0]

Is it possible to start a stored procedure asynchronously
in MSSQL7.0 (2000), i.e. - start and close the application, and the procedure continues to work on the server, without SQL Mail, etc.



TSV   (2001-11-30 20:12) [1]

I think, WAITFOR will help you. See Books Online for more details.

Good luck.



Delirium   (2001-12-03 12:11) [2]

> TSV
WAITFOR does nothing to help - it simply postpones the work of the procedure for some time WAITFOR DELAY (or from some point in time WAITFOR TIME).

> All
I looked here, you can create the sp_add_job task and run it sp_start_job, are there any other options?



TSV   (2001-12-03 13:13) [3]

Sorry, I didn’t understand the question. Then of course, through SQL Agent.



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top





Memory: 0.54 MB
Time: 0.021 c
3-21904
Andrei
2001-11-29 22:18
2002.01.08
query


4-22482
PONTIY
2001-11-01 10:06
2002.01.08
WinExec or ShellExecute


7-22426
inferno123
2001-09-25 10:32
2002.01.08
Port programming


1-22055
walker_ag
2001-12-19 03:27
2002.01.08
How to do it ?


1-22072
Garik
2001-12-19 11:08
2002.01.08
How to create a TFrame child instance dynamically





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish thai turkish Ukrainian urdu vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish