An SQL Server-scheduled job can run database commands or it can run Microsoft Windows commands in standard executable program files or in the PowerShell scripting language.

SELECT object_name, object_type, created, last_ddl_time, timestamp, status FROM user_objects; Run Operating System Commands from SQL*Plus One of my favorite commands in SQL*Plus is the host command.

SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

SQL (Structured Query Language) is a programming language used to communicate with and manipulate databases. Learn its history and when to use it.