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
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.
DeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
You have posted the blogs are really fantastic and informative.erp software dubai
DeleteHi 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
Very useful blog thanks for sharing IndPac India the German technology Packaging and sealing machines in India is the leading manufacturer and exporter of Packing Machines in India.
ReplyDeleteI like this post,And I guess that they having fun to read this post,they shall take a good site to make a information,thanks for sharing it to me. job posting
ReplyDelete
ReplyDeleteSuch a great blog.Thanks for sharing.........
Ethical Hacking Course in Chennai
Ethical hacking course in bangalore
Ethical hacking course in coimbatore
Ethical Hacking Training in Bangalore
Ethical hacking Training institute in bangalore
Ethical Hacking in Bangalore
Hacking Course in Bangalore
Ethical Hacking institute in Bangalore
Selenium Training in Bangalore
Software Testing course in Bangalore
I enjoy reading an article that can make people think dev. Also, thanks for allowing for me to comment!
ReplyDeleteInteresting and amazing how your post is! It Is Useful and helpful for me That I like it very much, and I am looking forward to Hearing from your next..
ReplyDeleteJobs in Dubai
I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work. seo
ReplyDeleteShipox is a complete delivery software solution for pickup and delivery.
ReplyDeletedelivery management system
delivery driver management app
courier service software
DMS software
parcel delivery software
delivery management system software
delivery management app'
delivery software
courier dispatch software
delivery planning software
courier delivery software
food delivery software
delivery route planning software
restaurant delivery software
courier software
delivery routing software
delivery dispatch software
route optimization software
delivery software
delivery scheduling software
logistics management system/software
Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way. T hank you so much.
ReplyDeleteDot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
Thanks Admin For sharing this massive info with us. it seems you have put more effort to write this blog , I gained more knowledge from your blog. Keep Doing..
ReplyDeleteRobotic Process Automation (RPA) Training in Chennai | Robotic Process Automation (RPA) Training in anna nagar | Robotic Process Automation (RPA) Training in omr | Robotic Process Automation (RPA) Training in porur | Robotic Process Automation (RPA) Training in tambaram | Robotic Process Automation (RPA) Training in velachery
IEEE Cloud computing DOamin is a general term for anything that involves delivering hosted services over the Internet. cloud computing projects The cloud projects for cse is a metaphor for a global network of remote servers which operates as a single ecosystem, commonly associated with the Internet. IEEE FInal Year Networking Projects for CSE Domains Networking Projects cloud computing is the delivery of computing projects services—including servers, storage, databases, networking projects, software, analytics, and intelligence
ReplyDeleteJavaScript Training in Chennai
JavaScript Training in Chennai
Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
ReplyDeleteAWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
ReplyDeleteAWS training in chennai | AWS training in annanagar | AWS training in omr | AWS training in porur | AWS training in tambaram | AWS training in velachery
Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
ReplyDeleteLucknow Chikankari Kurti
Thanks Admin For sharing this massive info with us. it seems you have put more effort to write this blog , I gained more knowledge from your blog. Keep Doing..Chikan Suits shops in Lucknow
ReplyDeleteInteresting and amazing how your post is!
ReplyDeleteLucknow Chikankari Saree
Thanks for sharing this post
ReplyDeleteApply CSP
Want to read more from you
ReplyDeleteCSP Apply
You can read my blog here
ReplyDeleteBank Mitra CSP
Thank for sharing this.
ReplyDeleteMile Solutions designed delivery software for small and medium type of business to manage deliveries in real time. For more details visit.
delivery management software
courier delivery software
retail delivery software
grocery delivery software
delivery driver app
laundry delivery software
ondemand delivery app
digital dispatch software
courier dispatch software
logistics management software
ecommerce delivery management software
software for logistics
food delivery software
delivery management software in uae
last mile delivery software
Your Blog is really awesome to read and useful for everyone,thanks for sharing such a wonderful article.keep updating..
ReplyDeleteAWS Certification Exam Center in Chennai | AWS Exam Center in Velachery | Best AWS Exams in Chennai
Your Blog is really awesome to read and useful for everyone, you can read my blog too from here
ReplyDeletereliance jio tower installation process
jio tower installation
jio tower installation rent
jio tower installation scheme
jio tower installation rent
jio tower installation request form
jio tower installation rent
jio tower installation application form
jio tower installation apply online
jio tower installation registration
Nice information. Thanks for sharing content and such nice information for me. I hope you will share some more content about. Please keep sharing!
ReplyDeleteRobotic Process Automation (RPA) Training in Chennai | Robotic Process Automation (RPA) Training in anna nagar | Robotic Process Automation (RPA) Training in omr | Robotic Process Automation (RPA) Training in porur | Robotic Process Automation (RPA) Training in tambaram | Robotic Process Automation (RPA) Training in velachery
Your Blog is really awesome to read and useful for everyone, you can read my blog too from here
ReplyDeleteAWS training in Chennai
AWS Online Training in Chennai
AWS training in Bangalore
AWS training in Hyderabad
AWS training in Coimbatore
AWS training
nice
ReplyDeleteAivivu vé máy bay giá rẻ
ReplyDeletevé máy bay tết 2021 Vietjet
vé máy bay đi Mỹ khứ hồi
ve may bay di Phap gia bao nhieu
bay hàn quốc mấy tiếng
vé máy bay việt nam nhật bản
thời gian bay từ Hà Nội sang Anh
Useful.salesforce training in chennai
ReplyDeletesoftware testing training in chennai
robotic process automation rpa training in chennai
blockchain training in chennai
devops training in chennai