To check current job execution status in SQL server the script is
EXEC MSDB..SP_HELP_JOB @EXECUTION_STATUS=1
This code will populate results of list of Jobs running in entire serverinstance, meaning across all databases.
This blog is to share/learn on several technical concepts such as DBMS, RDBMS, SQL Server, SSIS, SSRS, SSAS, Data Warehouse concepts, ETL Tools, Oracle, NoSQL, MySQL, Excel, Access, other technical and interesting stuffs
- SQL Server
- T-SQL
- Searches
- Checks
- Check size of databases in SQL Server
- Check size of tables in a database
- Find Currently running queries
- Check all SQL Server instances
- Check Job execution status
- List all the triggers of a database
- List all Jobs in the SQL Server
- Check database(MDF) and Logfile(LDF) saved locations
- Find Identity, Increment, Seed values and column name of all tables in a database
- If
- DynamicSQL
- Renames
- SET Statements
- MS Office
- CTE
- Nth findings
- Differences1
- Differences2
- GoodOne
- UDFs
- DBAdministraton
- SSIS
- SSRS
- SSAS
- Definitions
- MS Access
- Useful VBA Functions
- Create Autonumber ID field VBA script
- Field Exists check
- Capture counts in a column MS Access
- Hide columns with Access VBA
- Execute SSIS dtsx package from Access vba
- Drop table if exists
- Export data to Existing Excel Sheet
- Export excel from MS Access and perform Formatting
- Extract number after a specific word from a full length string
- Extracts
- VBA
- Connections
- Useful VBA Functions
- MS Excel
- Tech
- Contact
No comments:
Post a Comment