Execute a SQL job from SC
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!