Find Jobs
Hire Freelancers

T-SQL Code

$10-30 USD

Completed
Posted over 10 years ago

$10-30 USD

Paid on delivery
Here is a simple query run on the system msdb database that shows history of all the jobs that ran. I put a WHERE clause because I am interested in one particular job id. SELECT TOP 1000 [instance_id] ,[job_id] ,[run_status] ,[run_date] ,[run_time] ,[run_duration] FROM [msdb].[dbo].[sysjobhistory] where job_id = '5612777E' The job_id '5612777E' runs every five minutes so I need to have the query modified to check if the job id ran within last five minutes from current server time and display the status whether it ran successfull/fail/cancled etc. Purpose of this query is to basically run and it should tell is if "5612777E' ran in last fine minutes or it didnt. This should be quite easy for someone who is good with T-sql ( Please note we are on MS SQL Server 2008R2 and not oracle so code should be in T-sql)
Project ID: 5145909

About the project

26 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
[TASK DONE] Dear Sir, I'm MCITP ms sql server,I'm interested on doing this task. Kind Regards, NourElDeen
$15 USD in 0 day
4.9 (37 reviews)
5.2
5.2
26 freelancers are bidding on average $23 USD for this job
User Avatar
Dear, I am database and query writing expert. I can modify you current query. Please award me this project. Thanks
$33 USD in 0 day
4.9 (94 reviews)
6.4
6.4
User Avatar
Its really easy... Let me know how you will be notified? It can be a email sent from the database as well (for standard or enterprise version). Or let me know what will be the source of informing you. Thanks
$13 USD in 1 day
5.0 (33 reviews)
5.0
5.0
User Avatar
Hi, I'm very interested helping you resolving your sql query, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of databases modeling and database administration manual. I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. Please award me the project and send me all other details about your query, so we can start asap. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$34 USD in 1 day
4.5 (26 reviews)
5.2
5.2
User Avatar
Hi I have more than 10 years experience in MSSQL database administration. Please see my profile. Thanks.
$35 USD in 3 days
4.9 (30 reviews)
4.7
4.7
User Avatar
Hi I have already the query. Please hire me and I will send to you. Best Regards Ghazi Oualha
$10 USD in 0 day
5.0 (1 review)
4.3
4.3
User Avatar
Hello, I have been working with SQL Server for the last 4 years, I can help with this query. We just have to add some formatting functions and see if the difference in minutes between now and the run date& time is smaller than 5. I have the script ready. Best regards, Alex
$15 USD in 0 day
5.0 (5 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$40 USD in 0 day
4.9 (4 reviews)
3.9
3.9
User Avatar
Hi. I am certified MS SQL Server expert and have spent great deal of my life in performing administrative tasks. Would be glad to help you with this project. Regards, Yuri.
$35 USD in 2 days
5.0 (18 reviews)
3.7
3.7
User Avatar
Hi, I am an individual freelance, having more than 10yrs of exp in developing applications, window & web based, using .Net (C#.Net, Asp.Net (MVC), XML, WPF, WCF (Webservices) and SQL Server etc). By worked with Giants clients like Microsoft as a vendor, got expertise in delivering the quality code with in the time please see my profile. Awaiting for your positive response
$20 USD in 0 day
4.6 (5 reviews)
3.6
3.6
User Avatar
I will provide you 2 solutions: - first the simple query - second a stored procedure with minutes and job_id as parameter. Best Regards, Luca.
$20 USD in 2 days
4.7 (3 reviews)
2.7
2.7
User Avatar
Hi, I'm working at a university for nearly 8 years and my job is to create custom reports and exports using Transact-SQL, so queries like this, are everyday task for me and I expect no troubles or so. I'm ready to start immediately.
$15 USD in 2 days
5.0 (1 review)
1.6
1.6
User Avatar
Hi, Can be done nicely within your expected time & quality. I have 8.5+ years of experience in .net technologies specially in asp.net, c#, mvc, ms sql, wcf, web services along with reach experience in basic web technologies like css, html, javascript, jQuery, KnockOut, SammyJS, etc. Let me know if you need any information for the same. Appreciate prompt response! :) Regards & Thanks, Jitendra Chaudhari.
$30 USD in 1 day
5.0 (2 reviews)
0.8
0.8
User Avatar
A proposal has not yet been provided
$28 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I shall write the query as per requirement. I will also provide 7 day support should you need any modification. I will be reachable via my personal email and and cell number. Regarding payment, you can pay me after you are 100% satisfied. regards, Pundrick.
$27 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
As an experienced SQL Server Developer who has worked on all version's from SQL Server 2000 through to SQL Server 2012 I would be able to easily produce the query you need The likelihood is I would be able to provide you the query you need within a couple of hour of you awarding the project. I have written a number of queries that work with the system tables and I would have no problems meeting your requirements. If I can give you any information to aid your decision please let me know.
$25 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Expert in TSQL,ssis and ssrs. If given will return the code in not more than half a day. please let me know and please contact me to discuss furthur
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
We would make minor adjustments to your query in the project with a few converts etc. Already tested it here and it works like a charm!!
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Propunerea nu a fost încă furnizată
$25 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Woodland Park, United States
5.0
1
Payment method verified
Member since Nov 19, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.