Find Jobs
Hire Freelancers

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

$10-30 USD

I përfunduar
Postuar over 4 years ago

$10-30 USD

Paguhet në dorëzim
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. ++++++++++++++++++++++++++++++++++++++ ====================================================
ID e Projektit: 22777473

Rreth projektit

8 propozime
Projekt në distancë
Aktive 4 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
I dhënë për:
Avatari i Përdoruesit
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 në 1 ditë
5,0 (13 përshtypje)
4,2
4,2
8 freelancers are bidding on average $26 USD for this job
Avatari i Përdoruesit
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 në 7 ditë
5,0 (48 përshtypje)
5,7
5,7
Avatari i Përdoruesit
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 në 3 ditë
5,0 (63 përshtypje)
5,8
5,8
Avatari i Përdoruesit
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 në 2 ditë
5,0 (49 përshtypje)
5,2
5,2
Avatari i Përdoruesit
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 në 7 ditë
4,8 (3 përshtypje)
1,4
1,4
Avatari i Përdoruesit
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 në 1 ditë
5,0 (1 review)
0,2
0,2
Avatari i Përdoruesit
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 në 1 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i HONG KONG
Hong Kong, Hong Kong
4,9
66
Mënyra e pagesës u verifikua
Anëtar që nga maj 20, 2012

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.