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!