Purpose of the Article
This article is devised to give a way of running the jobs on demand irrespective of scheduled process. This is very useful in such a case when there is no fixed time for data processing. Incoming data can come anytime and at the same time, system should run the job for data processing. To achieve this, many times we schedule our jobs to run at every half an hour/ 10 mins/ 15 mins etc which in turn wastage of system resources. We can control unnecessary execution of job by using Seed file that tells to Job whether it has to start execution or not.
What is Seed File?
Seed file can be any type of blank file (.txt,csv,.xls) that can be used as input parameter to start the execution of any process. For quintessence-
IF Seed file is available
BEGIN
START THE PROCESS
END
ELSE IF Seed file is not available
BEGIN
BYPASS THE PROCESS
END
How to control the execution of jobs using Seed file?
1. To control the execution of jobs, we need an additional step that should be the first step of the job which should check whether seed file is available in the source folder or not.
2. If seed file is available then job should go to next step and execute as expected and at last step, Job should delete the seed file.
3. If seed file is not available in the source folder then Job should by pass the steps and should quit with reporting success.
Steps to control the execution of Jobs using seed file:
1. Create first step of the job for checking whether file is exists or not. For checking file existence and Deletion, we are using XP_FILEEXIST and XP_CMDSHELL extended stored procedures. Below is the code which checks whether file is exists or not.
If file exists, we are simply doing select 1
If file does not exists then we are raising the error with message- ‘Seed file is not available’
DECLARE @Flag INT
DECLARE @FilePath VARCHAR(500)
DECLARE @DelFilePath NVARCHAR(500)
SELECT @FilePath = '\\IND-SQL-01\Processing\Start_Processing.txt'
EXEC MASTER..XP_FILEEXIST @FilePath, @Flag OUT
IF @Flag = 1
BEGIN
SELECT 1
END
ELSE
BEGIN
RAISERROR('Seed File is not available',16,1)
END
GO
Fig showing the first step of the job for checking file existence
2. Create one more step that should be the last step of the job that should delete the seed file if exists to clean the source folder for next execution. Below is the code for deleting the file:
DECLARE @Flag INT
DECLARE @FilePath VARCHAR(500)
DECLARE @DelFilePath NVARCHAR(500)
SELECT @FilePath = '\\IND-SQL-01\Processing\Start_Processing.txt'
SELECT @DelFilePath = 'DEL' + SPACE(1) + @FilePath
EXEC MASTER..XP_FILEEXIST @FilePath, @Flag OUT
IF @Flag = 1
BEGIN
EXEC MASTER..XP_CMDSHELL @DelFilePath
END
Fig showing the last step of the Job for cleaning the seed file
3. Go to Step first then Edit then Advance. Set the below setting
a. On Success : Go to Next Step
b. On Failure: Go to Last Step.
4. Job Steps:
In this way, we can bypass the processing steps if seed file is not available and we can save unnecessary utilization of system resources required for execution of the job.
Conclusion
By using the above mentioned steps, we can implement on demand job execution functionality.
---------------------------- Author - Vishal Jharwade ----------------------------------
This blog is having a wonderful talk. The technology are discussed and provide a great knowledge toall. This helps to learn more details about technology. All this details are important for this technology. Thank you for this blog.
ReplyDeleteHadoop Training in Chennai
Hi Vishal Jharwade, This is just to let you know that how good you are writing. I read all your articles, all are nicely explained & having information which we can never get from anywhere except sqlcircuit.com. I love all your articles & request to keep writing the post.
ReplyDeleteSuperb explanation & it's too clear to understand the concept as well,thank you for your sharing
ReplyDeleteWeb Development Company In India
Thanks for posting this useful article,Keep updating such a Great information of Blog..
ReplyDeleteJava Training Institute in Chennai | Java Training in Chennai | Online Training Institute in Chennai
Thanks you for sharing the unique content.
ReplyDeleteLinux Training Institute in Chennai | No.1 Linux Training Institute in Chennai | Online Training Institute in Chennai
Wonderful Post..Thanks for sharing your informative article..
ReplyDeleteITIL Certification Exam Center in Chennai | ITIL Certification Training in Chennai
Really an amazing post..! By reading your blog post i gained more information.
ReplyDeleteSEO MOBILE MARKETING
The best thing is that your blog really informative thanks for your great information!
ReplyDeletecashew nuts suppliers and exporters in dubai
A4 paper suppliers and exporters in dubai
onion suppliers and exporters in dubai
potato suppliers and exporters in dubai
spices&grains suppliers and exporters in dubai
Thank you for this valuable information. I have got some important suggestions from it.Java Training in Chennai | Web Designing Training Institute in Chennai | DotNet Training Institute in Chennai
ReplyDeletevery nice post..
ReplyDeleteNo.1 IOS Training Institute in Velachery | Best Android Training Institute in Velachery | Core Java Training Institute in Chennai
I read this article. I think You put a lot of effort to create this article. I appreciate your work.
ReplyDeletethesis Writing Service
Nice Blog. Thank you for sharing.
ReplyDeleteERP in Chennai | ERP Providers in Chennai | ERP Software in Chennai | ERP Software Development Company in Chennai
Amazing work. c
ReplyDeleteSissy
Excellent post. Thank you for sharing.
ReplyDeleteHR Payroll Software | Leave Management Software | Attendance Management System | HR Management Software
Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
ReplyDeleteData Science training in rajaji nagar | Data Science Training in Bangalore
Data Science with Python training in chennai
Data Science training in electronic city
Data Science training in USA
Data science training in pune
ReplyDeleteThanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
digital marketing company in delhi
You have explained very exacty what has done very simply in this blog.
ReplyDeletecontact us:Livewire Velachery
hello sir,
ReplyDeletethanks for giving that type of information. Epoxy Grout manufacturer in delhi
Laminated Doors manufacturer in hubli
ReplyDeleteled lawn lights in delhi
ReplyDeleteThanks for giving great kind of information. So useful and practical for me. Thanks for your excellent blog, nice work keep it up thanks for sharing the knowledge.
Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
ReplyDeleterpa training in btm | rpa training in kalyan nagar | rpa training in electronic city | rpa training in chennai | rpa online training | rpa training in bangalore
Hmm, it seems like your site ate my first comment (it was extremely long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well as an aspiring blog writer, but I’m still new to the whole thing. Do you have any recommendations for newbie blog writers? I’d appreciate it.
ReplyDeleteTop 250+AWS Interviews Questions and Answers 2018 [updated]
Learn Amazon Web Services Tutorials 2018 | AWS Tutorial For Beginners
Best AWS Interview questions and answers 2018 | Top 110+AWS Interview Question and Answers 2018
Best and Advanced AWS Training in Bangalore | Amazon Web Services Training in Bangalore
AWS Training in Pune | Best Amazon Web Services Training in Pune
AWS Online Training 2018 | Best Online AWS Certification Course 2018
Mobile app development company in Gurgaon
ReplyDeleteYour very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
ReplyDeleteJava training in Pune
Java interview questions and answers
Java training in Chennai | Java training institute in Chennai | Java course in Chennai
Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore
ppc company in gurgaon
ReplyDeletewebsite designing company in Gurgaon
dry fruit Pouches supplier
ReplyDeleteCattle Feed Bags Manufacturer
Rice Packaging Bags Manufacturers
Excellant post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
ReplyDeleteBest Devops training in sholinganallur
Devops training in velachery
Devops training in annanagar
Devops training in tambaram
Played on BGAOC with big wins? NOT? Come to us as soon as possible and win with us. perfect all slots casino Come get your chance to win.
ReplyDeleteNamkeen Pouch Manufacturers
ReplyDeleteRice Packaging Bags Manufacturers
Pouch Manufacturers
we have provide the best ppc service in Gurgaon.
ReplyDeleteppc company in gurgaon
website designing company in Gurgaon
شركة عزل اسطح بالدمام
ReplyDelete
ReplyDeleteبسم الله الرحمن الرحيم نحن فى شركة الكمال تقوم بافضل انواع التنظيف العام وتنظيف الفلل بافضل
انواع العالميه التى تحافظ على السيراميك
شركة تنظيف منازل بحائل
شركة تنظيف بالطائف
شركة تنظيف بجازان
شركة تنظيف بحائل
شركة تنظيف مجالس وكنب بحائل
ونحن فى خدماتكم اربعه وعشرون ساعه وكل هذا بافضل الاسعار واقل التكلفة
Качественная лед лента разных цветов, герметичные и нет, я обычно беру в Экодио
ReplyDeleteشركة عزل بالدمام
ReplyDeleteشركة عزل اسطح بالجبيل
شركة مكافحة النمل الابيض بالاحساء
Your Blog is really awesome with useful and helpful content for us.Thanks for sharing ..keep updating more information.
ReplyDeleteAWS Training Institute in Chennai | AWS Certification Training in Velachery | AWS Exam Center in Chennai | AWS Online Exams in Chennai
Very impressive and interesting blog, it was so good to read and useful to improve my knowledge as updated one,keep updating..This Concepts is very nice Thanks for sharing.
ReplyDeleteAWS Training Institute in Chennai | AWS Certification Training in Velachery | AWS Exam Center in Chennai | AWS Online Exams in Chennai
Very impressive and interesting blog, this is the best place to get wonderful information thanks much for sharing here...
ReplyDeleteLinux Training Institute in Chennai | Linux Training Center in Chennai | Online Training in Chennai | Linux Certification in Chennai
Your blog is really useful for me. Thanks for sharing this useful blog..thanks for your knwoledge share ... superb article ... searching for this content.for so long.
ReplyDeleteAWS Training Institute in Chennai | AWS Certification Training in Velachery | AWS Exam Center in Chennai | AWS Online Exams in Chennai
Your blog is very useful for me,thanks for sharing such a wonderful post with useful information.keep updating..
ReplyDeletePython Training Center in Chennai | Python Certification Training in Chennai
Your Blog is really awesome with useful and helpful content for us. Thanks for sharing. Keep updating more information.
ReplyDeleteTally Training Institute in Chennai | Tally Training in Velachery
Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
ReplyDeleteJava Training in Chennai
Java Training in Coimbatore
Java Training in Bangalore
The blog which you have posted is more impressive... thanks for sharing with us...
ReplyDeleteSelenium Training in Chennai
Selenium Training
selenium testing course in chennai
Best selenium Training Institute in Chennai
Selenium training in vadapalani
Selenium training in porur
Python Training in Chennai
Hadoop Training in Chennai
Big data training in chennai
JAVA Training in Chennai
Really an informative blog...Thanks for sharing informative article with us...
ReplyDeleteManual Testing Training in Chennai
Manual Testing Course
manual testing course fees
Manual Testing training in vadapalani
Manual Testing training in Guindy
Mobile Testing Training in Chennai
core java training in chennai
DOT NET Training in Chennai
Hibernate Training in Chennai
Html5 Training in Chennai
Thank you for your efforts and I am inspiried with your written style.
ReplyDeleteIELTS Coaching in Chennai
Best IELTS Coaching centres in Chennai
German Language Classes in Chennai
Japanese Language Classes in Chennai
Best Spoken English Classes in Chennai
TOEFL Classes in Chennai
IELTS Coaching in Tnagar
IELTS Coaching in OMR
Excellent post, it will be definitely helpful for many people. Keep posting more like this.
ReplyDeleteBest ccna Training in Chennai
ccna Training in Chennai
ccna course in Chennai
Angular 7 Training in Chennai
AngularJS Training in Chennai
Ethical Hacking Training in Chennai
CCNA course in Ambattur
CCNA course in T Nagar
CCNA course in OMR
A big thanks for this sharing this awesome post with us.Read it recently and felt very happy on reading every bit of the blog.
ReplyDeleteSpoken English Classes in Chennai
Best Spoken English Classes in Chennai
IELTS Coaching in Chennai
IELTS Coaching Centre in Chennai
English Speaking Classes in Mumbai
English Speaking Course in Mumbai
IELTS Classes in Mumbai
IELTS Coaching in Mumbai
IELTS Coaching in Anna Nagar
Spoken English Class in Anna Nagar
This stays as one of the best and attractive post I have read yet. Great sharing this post.
ReplyDeleteEducation Franchise India
Spoken English Franchise
Franchise For Spoken English Classes
Top Education Franchise In India
Best Education Franchise In India
Computer Education Franchise
Education Franchise India
Computer Center Franchise
Education Franchise Opportunities In India
I have to agree with everything in this post. Thanks for useful sharing information.
ReplyDeleteHadoop Training in Chennai
Hadoop Training in Bangalore
Big Data Course in Coimbatore
Big data training in chennai
Big Data Course in Chennai
Big Data Training in Bangalore
DOT NET Training in Bangalore
Python Training in Coimbatore
Content Writer Services in Delhi
ReplyDeleteContent Writing Company in Delhi
Web Development Services in Delhi
Ecommerce Website Development Company in Delhi
Website Designing Company in Delhi
Website Designing Service in Delhi
Graphic Designing Company in Delhi
Graphic Design Services in Delhi
Logo Design Services in Delhi
Logo Design Company in Delhi
Very Nice information Keep sharing Thanks...
ReplyDeleteCSP Apply
CSP Online Application
Online CSP Apply
CSP Registration
CSP Online Application
CSP Provider
Digital India CSP
Your Blog is appriciatable and nice. Bharat CSP is nothing but a business contributor and technology services provider to different kind of banks.
ReplyDeleteApply CSP
CSP registration
CSP provider
bank CSP
CSP kisok
kisok banking
The article is so informative. This is more helpful for our
ReplyDeleteselenium training in chennai
selenium online courses best selenium online training
selenium testing training
selenium classes
Thanks for sharing.
Awesome and Valuable information in this blog. Pure Digital covers a wide range of services from hosting, building your first website to Website integrations and backend systems development.
ReplyDeleteWebsite Design Company in New Zealand
Website Development Company in New Zealand
Hosting Company New Zealand
Website Revamp Company in New Zealand
Web Hosting New Zealand
Thanks for giving great kind of information. Get Kiosk, CSP Mitra Banking Registration & Online Csp Application with Bank Mitra Website.
ReplyDeleteCSP Apply
CSP Online Application
Apply for CSP
Top CSP Provider in India
Apply Online For Bank CSP
Online Money Transfer
ReplyDeleteNice infromation
Selenium Training In Chennai
Selenium course in chennai
Selenium Training
Selenium Training institute In Chennai
Best Selenium Training in chennai
Selenium Training In Chennai
Rpa Training in Chennai
ReplyDeleteRpa Course in Chennai
Rpa training institute in Chennai
Best Rpa Course in Chennai
uipath Training in Chennai
Blue prism training in Chennai
Data Science Training In Chennai
Data Science Course In Chennai
Data Science Training institute In Chennai
Best Data Science Training In Chennai
ReplyDeletePython Training In Chennai
Python course In Chennai
Protractor Training in Chennai
jmeter training in chennai
Loadrunner training in chennai
Great blog thanks for sharing Leaders in the branding business - Adhuntt Media is now creating a buzz among marketing circles in Chennai. Global standard content creation, SEO and Web Development are the pillars of our brand building tactics. Through smart strategies and customer analysis, we can find the perfect audience following for you right now through Facebook and Instagram marketing.
ReplyDeletedigital marketing company in chennai
Nice blog thanks for sharing You have come to the right place. Karuna Nursery Gardens is the ideal place to begin your journey into landscape gardening. Our specialists have built some of the finest landscape garden in Chennai that too at the best price and amazing service.
ReplyDeleteplant nursery in chennai
Excellent blog thanks for sharing Shopping for international cosmetics in Chennai? Look no further, the Pixies Beauty Shop has got your back with hundreds of international brands to choose from, that too with the best value.
ReplyDeletebeauty Shop in Chennai
Pretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
ReplyDeleteDigital Marketing Course in Chennai
Digital Marketing Courses in Bangalore
digital marketing training in marathahalli
Digital Marketing Course in Coimbatore
Digital Marketing Course in Madurai
digital marketing training in btm