sql server - waiting for sqlcmd job to finsih before next batch step -

-

मैं वर्तमान में एक सीएमडी फ़ाइल में है .... 

  sqlcmd -s myserver -यू यूजर-पी पास -i स्टेप 1 एसक्यूएल -ए स्टेप 1 आउटपुट डॉट टाइमआउट 5 एसकेएलसीएमडी -एस माइस्सेर -यू यूज़र-पी पास -आई स्टेप 2 एसक्यूएल -ए स्टेप 2 आउटपुट डॉट टाइम टाइम 5 एसक्यूएलसीएमडी -स माइर्सरवर -यू यूज़र-पी पास -क्यू "एसएसई एमएसडीबी एक्सईसी sp_start_job @job_name = 'माइजोब'" एसक्यूएलसीएमडी -एस माइस्सेर -यू यूज़र-पी पास -i स्टेप 3 एसक्यूएल -ए स्टेप 3 आउटपुट। टीटी   
 एसक्यूएलजी रनिंग के बीच में और चरण 3, मैं चरण 3 पर जाने से पहले कार्य के लिए "प्रतीक्षा" कैसे कर सकता हूं?   
 
 
 जॉब्स एसिंक्रोनस द्वारा डिज़ाइन चलाएं  
 हालांकि, आप step3.sql में लुक के लिए प्रतीक्षा कर सकते हैं और  dbo.sysjobs  जॉब की वर्तमान स्थिति के लिए  dbo.sysjobactivity  में शामिल हो सकते हैं। ।

Comments

Post a Comment

Popular posts from this blog

c++ - Cmake produces file extensions in static library archives -

-
I have recently switched to autotools to cement, since the limiter cross platform is better for development and what I saw When I build a stable library of my C ++ code, all the files inside .cpp.o is a suffix ar income tax PA8 / libgenericTZR.a genericTZR.cpp.o I have seen other libraries made by other tools and they do not do it, I'm not sure this is the realm And there is a bad thing, but how can I create static libraries without cpp file extension? This is my CMake file add_executable (PA8 ISP_Charges.cpp genericTZR.cpp genericTZR.h) set (LIBSRC genericTZR.c genericTZR.h) add_library (genericTZR shared $ {LIBSRC}) add_library (genericTZR shared $$ TARGET_OBJECTS: myObjects & gt;) install add_library (Generic TZR-static static $ {LIBSRC}) set_target_properties (Generic TZR-Static Properties OUTPUT_NAME $ install (TARGETS PA8 DESTINATION BIN) TARGETS GENICTZR GENERICTZR-STATIC DESTINATION lib) Installed (files "$ {PROJECT_BINARY_DIR} /PA8/genericTZR.h...
Read more

c# - Roxy file manager in MVC doesn't accept session path -

-
Hi friends I've downloaded a file manager for my MVC project. So I added to my project and everything works fine but everyone can use this product I mean everyone can type urls and upload files to my host !!!! This filemanager has a Jason config file, as you can see here: {"FILES_ROOT": "Fileman / Upload "," "File_type_kenny": "file", "THUMBS_VIEW_WIDTH": "140", "THUMBS_VIEW_HEIGHT": "120", "PREVIEW_THUMB_WIDTH": "300", "PREVIEW_THUMB_HEIGHT": "200", "MAX_IMAGE_WIDTH": "0" "ASP_net / Main.Shex? A = Created", " Dealederer ":" ASP_net / MAN.assx "ADELEDED IR "," MOVEDIR ":" ASP_net / Main.Shex? A = MoVEDIR "," Copdier ":" ASP_net / Main.Shex? A = Copdier "," Richie Dar ":" ASP_net / Main ASP_net / main.hex? A = Upload "," Downlo...
Read more

c# - Check if a NumericUpDown has no value -

-
How can I check that the user left a NumericUpDown control blank? I have looked at another question to examine the 'text' property but there is no text property to check against it. You can check against the text property, though it is a designer and Is hidden from Intelligence. Just try this sample it works: if (string.IsNullOrEmpty (control.Text)) {// a value}
Read more