Tagged Questions
0
votes
3answers
95 views
SQL agent job step's connection managers
Is there any way with T-SQL to list the connection managers that are used in an SQL Agent Job step?
3
votes
2answers
99 views
Update strings for all cmdexec Jobs
Does anyone know if it's possible, (and furthermore advisable) to update all cmdexec strings in jobs on a server?
We'd like to change our logging location, and in principle I'd think this could be ...
3
votes
1answer
40 views
Creative workaround for granting edit rights to individual jobs for a group?
We have two developers that say they can not function without full rights to a few jobs on our database server. They both want rights to the same jobs.
Given that it seems that MS doesn't seem to be ...
2
votes
2answers
314 views
How to find when last reindexing happened in sql server?
I have set 'job' for re-indexing, I want to know when the last re-indexing happened in datetime.
2
votes
0answers
66 views
Configuring SQL Server Job agent
I am trying to configure the SQL Server Job Agent using the following scripts
USE [msdb]
GO
CREATE USER [mydbuser] FOR LOGIN [mydbuser]
GO
EXEC sp_addrolemember N'db_datareader', N'mydbuser'
GO
EXEC ...
3
votes
2answers
439 views
Transaction and Try-catch in SQL Server Job
We have DML operations in each step of a SQL Server job. To ensure the update/insert will be rolled back in case something goes wrong, I have wrapped the data modifications of each step in TRY CATCH ...
0
votes
1answer
109 views
SQL Server Job logging best practice
To be able to design a robust Job in SQL Server, we need to have log for each step of the job. I know there are different options available which help us for troubleshooting a job, but what if we want ...
8
votes
2answers
247 views
How does SQL Server store the information in Job Schedule Properties?
I know there is SELECT * FROM msdb..sysjobschedules, but that just shows the next time a job is scheduled to run.
I want to know how this is all determined and stored. So where does it store the ...
