Find Jobs
Hire Freelancers

Need help SQL Server Express with SQL Server Agent calling stored procedures every 5 mins

$10-30 USD

Completed
Posted over 4 years ago

$10-30 USD

Paid on delivery
Additional notes: ========================== Have a sql exception: "ErrorNumber ErrorMessage 13609 JSON text is not properly formatted. Unexpected character 's' is found at position 0." In my sql: INSERT INTO WEBSCRAPE_TEMP (CASEPACK,CATEGORY,COST,DESCRIPTION,description2,itemno,page_url,pk_size,style,upc,upc_variant,variant,vendor,page_title) SELECT * FROM OPENJSON((select * from @json), N'$.[login to view URL]') WITH ( [CASEPACK] nvarchar(max) N'$.casepack', [CATEGORY] nvarchar(max) N'$.category', [COST] nvarchar(max) N'$.cost', [DESCRIPTION] nvarchar(max) N'$.description', [description2] nvarchar(max) N'$.description2', [itemno] nvarchar(max) N'$.itemno', [page_URL] nvarchar(max) N'$.page_URL', [pk_size] nvarchar(max) N'$.pk_size', [style] nvarchar(max) N'$.style', [upc] nvarchar(max) N'$.upc', [upc_variant] nvarchar(max) N'$.upc_variant', [variant] nvarchar(max) N'$.variant', [vendor] nvarchar(max) N'$.vendor', [page_Title] nvarchar(max) N'$.page_Title' ); --- This is because an object with sp_oacreate to get the text of the web page, and you are limited to 4000 bytes at a time, need to find a way around the 4k limit. -- Need a way around this 4k limit in addition to the scheduling with some automated run task. ------------------------ I am not 100% sure if SQL Server Express can work with SQL Server Agent. I have added a user with admin rights to Windows and to SQL Server database users and then bound the Sql Server Agent service to the user and it's not starting. Main objective is to get Sql Server Agent to call my stored procedures every 5 -10mins. Here is the output log: [login to view URL]: ================ 2019-12-08 22:33:21 - ? [000] Event Global\sqlserverRecComplete$SQLEXPRESS opened 2019-12-08 22:33:21 - ? [100] Microsoft SQLServerAgent version 14.0.2027.2 (X64 unicode retail build) : Process ID 872 2019-12-08 22:33:21 - ? [495] The SQL Server Agent startup service account is GMD-V9-MAIN\SqlServerAgent. 2019-12-08 22:33:21 - ? [393] Waiting for SQL Server to recover database 'msdb'... 2019-12-08 22:33:21 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs) 2019-12-08 22:33:21 - ! [000] The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229) 2019-12-08 22:33:21 - ! [298] SQLServer Error: 229, The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (DisableAgentXPs) 2019-12-08 22:33:21 - ! [000] The EXECUTE permission was denied on the object 'sp_sqlagent_update_agent_xps', database 'msdb', schema 'dbo'. [SQLSTATE 42000] (Error 229) 2019-12-08 22:33:21 - ? [098] SQLServerAgent terminated (normally) ==================================================== ********************** IMPORTANT: ********************** Please note that if you can really understand English, please put the color of the sky as the first word in the proposal. This will let me know you read through this requirement and you are detailed oriented person. ++++++++++++++++++++++++++++++++++++++ ====================================================
Project ID: 22777473

About the project

8 proposals
Remote project
Active 4 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
Blue . Hello, I am core sql dba with 10+ years of experience. Sql agent won't be supported in express edition. I have other options and solutions to get this done . I also provide long term support , if you are interested . I am proficient in sql server development and administration . I grantee you will get top notch support. Please message me , we will discuss and take it forward .
$15 USD in 1 day
5.0 (13 reviews)
4.2
4.2
8 freelancers are bidding on average $26 USD for this job
User Avatar
blue is the color of sky Hello, i'm an expert IT with more 15 years of experience in IT industry . i'm certified Cisco networking professional 300-100 and 300-115 and Linux professional lpi 101, 102 and RHCSA and VCP 4, 5,5.5 and Data Center and MSCA/MSCE ranging from 2003 to 2012 . i'm ready to fix your issue now
$30 USD in 7 days
5.0 (48 reviews)
5.7
5.7
User Avatar
Hi SQL Server Agent does not support JOBS creation, you can trust the execution of the store procedure to windows service for example. I would like to talk to you by chat Experience to apply: Microsoft platform: Language: VB.NET / C # ASP.net / Web Form - / MVC MySql Server / SQL Server About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications created with Asp.net and SQL Server 2005, 2008 and 2012
$28 USD in 3 days
5.0 (63 reviews)
5.8
5.8
User Avatar
Blue is an Answer on question about the color of sky. About me: Senior SQL Developer with 10+ years experience, worked during this time with several automation systems, Business Intelligence tools. Five years working within scrum team in USA product company. Also during my professional activity i gathered expertise and experience in several areas of IT from configuration development environment to delivery of developed product. Areas of specialization: ● MS SQL Server DB Engine ● T-SQL ● MS Reporting Services ● DWH ● MS Integration Services ● ETL Processes ● MS Analysis Services
$30 USD in 2 days
5.0 (49 reviews)
5.2
5.2
User Avatar
Blue Hello, How are you, I am a software professional and a full stack web developer, making websites and software for the last 8 years. I have completed several projects . I went through the description of the project. I can do the job with very high quality, mentioned in the description. I have expertise in : SQL Windows Server Microsoft SQL Server Core PHP , CodeIngniter , Wordpress Website Design Graphic Design WordPress HTML I can show you my real project, once we come on an online chat. Thank you for your time and consideration.
$20 USD in 7 days
4.8 (3 reviews)
1.4
1.4
User Avatar
Experience : I have 12+ years experience as an IT Infrastructure Manager, I have Strong Experience in AWS, Azure, Windows Server, Linux, Network, Firewall, Office 365, Google Gsuite, Zoho mail, VoIP Tools Like Asterisk, 3CX, Sip foundry, Cloud Pbx, etc, also worked in Vmware , HyperV , web hosting tools Cpanel , Plesk , etc , Till now I have completed 1 Projects in FREELANCER.COM, related to Windows Server and Cloud. Certification : I have completed my MBA in Systems, BSc in Information Technology, Certified as an MS Azure Architect Expert, MCSA, MCSA Messaging, CCNA, CCNA Security and ITIL, kindly refer to my profile and consider my application.
$30 USD in 1 day
5.0 (1 review)
0.2
0.2
User Avatar
Light Blue or Grey:) ! Hi There, I have Been working in SQL and VB, .NET, other BI combinations for around 15 years. this issue could be fixed if you follow the steps of creation and services however, It would be good to work with you and fix it. looking forward to work with you and share the solutions. thank you,
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of HONG KONG
Hong Kong, Hong Kong
4.9
66
Payment method verified
Member since May 20, 2012

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.