Skip to content
+1-888-319-3663

COMMUNITY FORUM

Execute a SQL job from SC

Sherry Whitten asked 7 years ago
I have a SQL Server Agent Job that users periodically need run. Right now, they call me, and I log onto the SQL server and run it for them. I think I could set this up so they could execute it themselves from a SmartConnect map, since they’re in SC all day any way. 1. Create a fake source file. Maybe just the name of the map. 2. Map a destination of export to excel file. Maybe include the name of the map and the date? We could use this to track when it is run. 3. Add a Task to Run SQL Command. Put the SQL Query in here that will run the job. Something like: USE msdb ; GO EXEC dbo.sp_start_job N’Weekly Sales Data Backup’ ; GO Anybody have a better suggestion or thoughts on whether or not this will work? Any pitfalls? Thanks!
Answers
Best Answer
lorren answered 7 years ago
Sherry,

There isn't a reason that you shouldn't be able to execute that SQL job. My only thought is there is a rights issue.

If you would like to submit an answer or comment, please sign in to the eOne portal.