Support Center

Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

SQL Express Support

Jason Van Pee Mar 23, 2017 12:27PM CDT

Do the MinionWare solutions require SQL Agent? We use SQL Express for a few small databases and would like to use the MinionWare solutions on them. We currently use an enterprise automation solution to schedule our SQL maintenance on those instances.

Thanks much,

Jason

3 Community Answers

Best Answer
Sean McCown Mar 23, 2017 10:48PM CDT

The jobs are definitely agent jobs, but the jobs themselves only call the SP. So you can run them from any app that can connect to SQL and run an SP. If you have an enterprise automation tool, there’s no reason I can think of why you wouldn’t be able to connect to sql and call the SP the same way the agent job does. You could also even do it from a script called by windows scheduler if you wanted.

View in conversation


Up 0 rated Down
Sean McCown Best Answer Mar 23, 2017 10:48PM CDT MinionWare Agent

The jobs are definitely agent jobs, but the jobs themselves only call the SP. So you can run them from any app that can connect to SQL and run an SP. If you have an enterprise automation tool, there’s no reason I can think of why you wouldn’t be able to connect to sql and call the SP the same way the agent job does. You could also even do it from a script called by windows scheduler if you wanted.

Up 0 rated Down
Brad Griffin Apr 04, 2017 05:53PM CDT
Have done exactly that. We have moved a lot of 3rd party databases to a new server using SQL Express 2016. We have now configured an SP to allow it to send email and we have used a combo of batch files (running SQLCMD) and a series of SQL files in the Task Scheduler. It works a treat
Up 0 rated Down
Sean McCown May 08, 2017 08:36AM CDT MinionWare Agent

Closing the case.

Post Your Public Answer

Your name (required)
Your email address (required)
Answer (required)
556ca399015f31edc97a62de2771be1a@minionware.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete?b_id=8420